MySql table name stored in php

[Dawie]

Hi

 

I\'m storing a MySql table name in a PHP variable e.g.

 

$tbl = \"example\".$coy;

 

Why does:

$sql_command = (\"SELECT * FROM \'<?php echo $tbl; ?>\' WHERE id = \'$id\'\");

not work? Is there a way to do it? I unfortunately HAVE to store the table name in a variable cuz it is different for different companies.

 

Thanks

[Alien]

I am not sure why you have parentheses.

 

try this

$sql_command = \"SELECT * FROM \" . $tbl . \" WHERE id = \'$id\'\";

[Dawie]

Thanks, I was a bit confused with the syntax.. but then, I\'m also a newbie =