Weird :( Query

What is the problem with this line

$resultstar = mysql_query("SELECT * FROM $cat WHERE active=0 and rest_id=$rest_id",$db);

Warning: Supplied argument is not a valid MySQL result

any idea ?

That error might signify that something is wrong with your $db variable.

if you are not doing multiple database connections try this.

$resultstar = mysql_query("SELECT * FROM $cat WHERE active=0 and rest_id=$rest_id");

else
post your connection code.

Ace21

if i change the $cat with my database name it's working, but i dont want to do that.
i want that $cat to be phrase from the URL

does $cat have a value for sure? if it does then try '$cat'.

Ace21

yes $cat has a value from the URL

index.php?cat=book

Newbie suggests ...

don't you have to say:
WHERE ..... AND
WHERE .....

Thereby using WHERE for each different item to test against?

No, you only need to have WHERE in there once...For example:

SELECT * FROM your_table WHERE ID='3' AND (Name='BoB' OR Name='Joe') AND Country='USA'

That would be a valid where clause if you have a table setup like that 😉

-JoshB