[SOLVED] MySQL throws an error on a simple query...

[mattal999]

Ok so, this is the code:

 

mysql_query('UPDATE imuzic_mp3 SET valid=\'-2\', last_checked=\''.date('Y-m-d H:i:s').'\' check_now=check_now+1 WHERE id=\''.$mp3['id'].'\'') or die(mysql_error());

And this is the result:

 

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'check_now=check_now+1 WHERE id='36'' at line 1

 

Any ideas? The query is simple. It just throws an error for no reason...

[mikesta707]

forgot a comma.

 

mysql_query('UPDATE imuzic_mp3 SET valid=\'-2\', last_checked=\''.date('Y-m-d H:i:s').'\', check_now=check_now+1 WHERE id=\''.$mp3['id'].'\'') or die(mysql_error());

 

 

[mattal999]

forgot a comma.

 

mysql_query('UPDATE imuzic_mp3 SET valid=\'-2\', last_checked=\''.date('Y-m-d H:i:s').'\', check_now=check_now+1 WHERE id=\''.$mp3['id'].'\'') or die(mysql_error());

 

Damn. I completely missed that. I swear I hit the comma key

 

Thanks anyway.