mySQL query

[Anon]

Hello everbody,

I have question about a mySQL query that is failing, can somebody tell me whats wrong?

1)This one works;
$result = mysql_query("SELECT prod_id, prod_name, prod_description_small FROM store_products ORDER BY prod_name limit $offset,$limit");

2)But it must have a WHERE statement in it;
$result = mysql_query("SELECT prod_id, prod_name, prod_description_small FROM store_products WHERE prod_category=$prod_cat ORDER BY prod_name limit $offset,$limit");

And number two is failing whith this error:
Supplied argument is not a valid MySQL result resource in line x

What am I doing wrong?

Kind regards
Maarten Elsenaar

[Anon]

Hi,

Did you test the second query on the mysql-commandline? For I can't see syntactical errors it seems the query doesn't find any records.
Best regards,

King Louie

[Anon]

Well there is data in the database, but it's on a remote server and I can't get to the command prompt?

Could this be a problem on the server?

[Anon]

I found the problem;
The variable in the where statement is now between '' .....
And now it works???

Thanks for your time!