MySQL returned table issue....
Posted: Mon Apr 03, 2006 11:17 pm
Been trying to figure this out all day
I can't quite get this to work like I want.. how can I fix it because it's important the database is is a variable not hardcoded...
Do you guys know how i can fix this, the great feyd or jcart?
Peace.
Code: Select all
$mysql_table = "user0101_db";
$sql = "SHOW TABLES";$sql = mysql_query($sql);// or die('WTF:'.mysql_error());
echo "$mysql_table <br><br>";
while($object = mysql_fetch_object($sql))
{
echo $object->Tables_in_.$mysql_table; // doesn't work
echo $object->Tables_in_user0101_db; // works
}Do you guys know how i can fix this, the great feyd or jcart?
Peace.