Hi All
Here's my situation. I'd like to add a table prefix to all the mysql calls in one of my perl scripts. I'm gonna put the following in the config file, and then make the adjustments:
The problem for me is how to add it to the calls in the scripts. For example, is adding $dbprefix as simple as the following, or should I have some quotes or something in there:
$dbprefixusers WHERE username = ?';
Thanks a bunch
------------------------------------------
Here's my situation. I'd like to add a table prefix to all the mysql calls in one of my perl scripts. I'm gonna put the following in the config file, and then make the adjustments:
Quote:
$dbprefix = 'fred_';The problem for me is how to add it to the calls in the scripts. For example, is adding $dbprefix as simple as the following, or should I have some quotes or something in there:
Code:
$statement = 'SELECT * FROM $dbprefixusers WHERE username = ?';
Thanks a bunch
------------------------------------------
Adding Table Prefix to mysql call - perl