plz help with this sql statment

[Anon]

hi i am tring to execute this sql statment

$query="select * from $table where id=$id and cat=$cat" ;

i am getting the $table from the query passed from other page...and when i try to run the query i get an error saying sql statement is wrong. and its becuz $table in the query.

is there anyway i can fix it...

i know i can use the if or select statment or work the query i want but i have too many things...

plz help

thank

[bike5]

Try.....

$query="select * from $table where id='$id'and cat='$cat'" ;

[Anon]

So if you put the name of a real table in where you have "$table" now, it works? That makes it sound to me like $table doesn't have the value it's supposed to there.