so close yet so far!

[kev wood]

i thought i had this working but alas i was wrong.  the variable $table is getting posted to the page via a hidden form input, and i know this because it lets me echo it out.

 

the problem lies in this code somewhere.

 

$run=mysql_query ('SELECT max(id) from $table') or die(mysql_error());
$lastid = mysql_fetch_row($run)or die(mysql_error());
$lastid=$lastid[0]or die(mysql_error());
$sql="UPDATE $table SET image= '$consname2'  WHERE id= '$lastid'"or die(mysql_error());
$query = mysql_query($sql)or die(mysql_error());

 

when i select the image to up load i get the error

 

Table 'xxxxxxxxxdb.$table' doesn't exist

 

why will it let me echo the variable but not let me use it inside the query.

[gevans]

$run=mysql_query ("SELECT max(id) from $table") or die(mysql_error());

 

Use double quotes if you want PHP to find a variable within them

[kev wood]

thanks for the reply i will try that.