[Resolved] Dynamically choosing table in MySQL

gregorya

Is it possible for me to dynamically choose which table to pull from.

say with something similar to this.
$db=db_connect();
$table="1";
$id="12";
$sql="SELECT * FROM $table WHERE id='$id'";
$results=mysql_query($sql);
$myrow=mysql_fetch_array($results);
foreach($myrow as $key => $value)
echo $key."-".$value."<br>";

when I have tried this I get this message

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/playhava/public_html/b.php on line 9

Warning: Invalid argument supplied for foreach() in /home/playhava/public_html/b.php on line 10

can i do this or should I try something else?

TruckStuff

Do you know the query is executing properly? I'd do something like the following:

$db=db_connect();
$table="1";
$id="12";
$sql="SELECT * FROM $table WHERE id='$id'";
$results=mysql_query($sql) or die ('Could not fetch data: '.mysql_error());
$myrow=mysql_fetch_array($results);
foreach($myrow as $key => $value)
echo $key."-".$value."<br>";

BigE

echo the value of $sql before you execute the query. That should reveal the problem. I use a function for query execution that automatically displays the query before it executes if a global debug variable is turned on. Makes it easy to spot errors in how the query was built.

-E

Roger_Ramjet

I'm wondering about your table names. If the example is true, then you are using integers as table names. I suspect that the number is being morphed into a double somewhere along the way. Try using quotes around it to force it to a string name instead of a binary number.

Try this , or something like it:

$sql="SELECT * FROM '$table' WHERE id='$id'";

Use ths syntax when developing:

$results=mysql_query($sql) or die ($sql . '<br />' . mysql_error());

It will display your query and the error text if your query fails. Usually it some slash/stripslash problem or other and you need to know exactly what was being passed to the DBMS.

gregorya

I figueerd it out. I just needed the ``around the table name to use numbers as a table. Thanks for all the help though.