Originally Posted by mtishetsky

Then are you sure you get this error exactly for this query?

Its my first SQL query. And nothing happens after that line.(debug of echo's)

I've also gone as for to do the statement in phpmyadmin, and copied the code it used with some very minor adjustments. :S and still it screws up.

This error baffles the hell out of me.

So this is obviously a poltergeist. I'm afraid we are unable to help you.

I would recommend you to create a script which does nothing but the following:

PHP Code:

mysql_connect();
mysql_select_db();
$sql = "your misterious query";
$res = mysql_query($sql);
var_dump(mysql_fetch_object($res)); 


The point is to exclude any wrappers such as DB class or whatever. If this works there is a problem somewhere else.

Also please post the resulting query itself. Echo or error_log it right before doing mysql_query().

I get the following:

Resource id #3
bool(false)

Solved...Although I don't quite understand how it was solved. I just restarted apache/mysql/php...for the 10th time. -shrug- Oh well. thank you everyone! Talk++ for all of you.