[Resolved] accessing a table created from php with a variable name

VisionsOfCody

I need to select a table that's just been created and whose name is an ID number in a variable called $ID, like this

mysql_query("CREATE TABLE `".$ID."` (`prenom` MEDIUMTEXT NOT NULL, `nom` MEDIUMTEXT NOT NULL,`email` MEDIUMTEXT NOT NULL, `fonction` MEDIUMTEXT NOT NULL)")or die("Create table Error: ".mysql_error());

that works fine, but I don't know how to access it using the same variable
I've tried this :

$res = mysql_query("SELECT * from '".$ID."'");

and

$res = mysql_query("SELECT * from $ID");

but they don't work (supplied argument is not a valid MySQL result resource .... etc etc)

what's the standard way of doing this ?

thanks
😃

VisionsOfCody

i just found out that it wasn't the syntax, as i changed the query to this

$string = "SELECT prenom,nom,email,fonction FROM ".$ID;
		print $string . "<br>";
		$query = mysql_query($string)or die(mysql_error());

the problem was the fact that i was naming my tables with an ID number

20041021094107

and it doesn't seem to like that so I put a "t" at the start and it works fine

t20041021094107

so there you go. Hope someone else can benefit from my mistake!

😃