Weird mySQL Error!

[kamy99]

Hi:

I just moved from my development server to my live server and suddenly got a weird mySQL error.

$sql=mysql_query("SELECT cat_title_eng,cat_id FROM categories WHERE cat_publish='1' AND cat_title_eng != '' AND cat_parent='0' ");

I get the standard error: supplied argument is not a valid MySQL result resource

I have to mention that the code works perfectly in my dev server AND a weird thing is that when I try the code with one AND like:

$sql=mysql_query("SELECT cat_title_eng,cat_id FROM categories WHERE cat_publish='1' AND cat_title_eng != ''  ");

It works , (doesn't matter which two arguments I use)

Any ideas?

thanx

kamy

[bradgrafelman]

Yes. The debugging thread link is in my sig... use it to figure out how to debug MySQL queries. Once you've figured that out, post the error that MySQL is telling you, not PHP.

EDIT: On a hunch, you might be mixing up column types with data types - i.e., if "column1" is a numeric type (integer, floating point, etc.), then you CAN NOT compare its contents with strings, like this:

... WHERE `column1`='1234' AND ...

The quotes around 1234 indicate to MySQL that it should treat the data as a string. A correct query for a numeric column like this would look like:

... WHERE `column`=1234 AND ...

Anyway... just a guess. Read more about SQL error debugging and get back to us on the exact MySQL error.