[SOLVED] mysql query error problem

[shedokan]

I have this query wich won't work:

UPDATE `teams` SET `ssl`=ssl+1, `ssc`='1215867984' WHERE `id`='1'

and this query wich works:

UPDATE `teams` SET `ssw`=ssw+1, `ssc`='1215867984' WHERE `id`='4'

 

and I get this error:

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 'ssl+1, `ssc`=1215867984 WHERE `id`='1'' at line 1

 

I used the first query on 16 tables but with different id's and it worked only about half of the times.

please help.

[mmarif4u]

Are you sure that id 1 exists in table.

[rarebit]

I was going to ask if the 'ssl' field existed?

[PFMaBiSmAd]

ssl is a reserved mysql keyword. You have back-ticks around it in part of your query but not everywhere. Be consistent when writing code.

[shedokan]

thanks you PFMaBiSmAd I didn't know that.

from now on I will always use back-ticks.

 

thanks.