Put a Variable in mysql commands???

[Jamez]

Ok - I'm trying to setup everything in a script i made so that it is easy to install on different servers, only changing variables in file instead of all files.

I need to set a variable inside of a php/mysql command and I'm not sure how to do so....

mysql_select_db("username_dbname");

I have 2 variables, $username and $dbname, i need to get them inside the select_db but I don't know what syntax to use 😕

[TheDefender]

First, create a link using mysql_connect, and then use that link in the mysql_select_db function. Check the php manual for both of these functions, and you'll see examples of how this is implemented. If you aren't sure what I mean, post what you have, and we'll help you correct it.

$link = mysql_connect('localhost', $username, $password);
mysql_select_db($dbname, $link);

[Jamez]

I ended up using this,

include 'variables.php'; 
mysql_select_db($sqldb);  

with this inside the variables.php file

$sqldb = "bl33ch_shopcart";

Seems to be working ok 🙂

Now i just have to figure out the best way to make auto-thumbnails out of uploaded images :bemused: