[Deansatch]

I want to write this and have $username replaced with the contents of the username field from database1 and "table1_$username" is a table in database2

PHP Code:

$query = mysql_query("SELECT * FROM table1_$username ORDER BY id DESC") or die(mysql_error()); 

I tried this during pulling my hair out and I think I am on the right track but can't get it to work. Where am I going wrong?

PHP Code:

require("config.php");

require("functions.php");

$connection = mysql_connect($host,$usr,$pwd);

mysql_select_db('database1') or die('Cannot select database'); 

$username = mysql_db_query($db, "SELECT username FROM table_customers where id='$id'", $connection);





$connection = mysql_connect($host,$usr,$pwd);

mysql_select_db('database2') or die('Cannot select database'); 



$query = mysql_query("SELECT * FROM table1_$username ORDER BY id DESC") or die(mysql_error()); 

but it just doesn't work. I can either get
"Table 'databse2.table1_' doesn't exist "
or
"Table 'databse2.table1_Resource' doesn't exist "

[duesi]

$username does not yet contain the username, it is just a reference to your result.

you need :

PHP Code:

require("config.php");

require("functions.php");

$connection = mysql_connect($host,$usr,$pwd);

mysql_select_db('database1') or die('Cannot select database'); 

$username = mysql_db_query($db, "SELECT username FROM table_customers where id='$id'", $connection



//Normally you need a loop here, but I assume you have a UNIQUE

//KEY on id??

$row = mysql_fetch_array($result, MYSQL_ASSOC));

$username = $row["username"];



$connection = mysql_connect($host,$usr,$pwd);

mysql_select_db('database2') or die('Cannot select database'); 



$query = mysql_query("SELECT * FROM table1_$username ORDER BY id DESC") or die(mysql_error()); 

But like in your thread

http://www.programmingtalk.com/showthread.php?t=30765

I wonder why you are doing this, it is very uncommon to have dynamic tablenaes, it makes everything very complicated....

Cheers!