Invalid sql statement

[jonsof]

I have the following statement below

SELECT c.category FROM categories c, announcement a WHERE c.categoryid=a.categoryid

I can;t find where the error is

could you help me?

[xblue]

let mysql (it probably is mysql?) help us 🙂

does

mysql_query("SELECT c.category FROM categories c, announcement a WHERE c.categoryid=a.categoryid") or die (mysql_error());

return an error?

[jonsof]

Yes, it is mysql

The error message is "Invalid argument...."

and ultimately i came up with this!

[xblue]

this is after inserting "or die(mysql_error())"?
sorry that I ask again, it is just because mysql errors often are a little more specific (and thus helpful).