Mass Update (MySQL & PHP)

[SiGmA_X]

Okay, still is erroring..[sql]UPDATE pchm_affiliates SET impressions = IF (

id = 8,
'977',
IF (
id = 3,
'2062',
IF (
id = 4,
'996',
IF (
id = 7,
'941',
IF (
id = 5,
'1797',
IF (
id = 10,
'942',
IF (
id = 1,
'1976',
IF (
id = 6,
'1963',
IF (
id = 2,
'1973',
IF (
id = 9,
'940',
IF (
id = 11,
'834'
)
)
)
)
)
)
)
)
)
)
) WHERE id IN ( 8, 3, 4, 7, 5, 10, 1, 6, 2, 9, 11 ) [/sql]

Error:
MySQL said: 

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 
') ) ) ) ) ) ) ) ) ) ) WHERE id IN ( 8, 3, 4, 7, 5, 10, 1, 6, 2,

Help?

[filburt1]

Do you have the correct number of closing parens? Also you'll need a final dummy ELSE value.

[Xenon]

exactly a final , '' before the first closing ) is needed

[SiGmA_X]

Thank you Xenon, I see now. 1 sec.. Awsome! It now works Thank you all.

Oh, and about that count problem I was having.. I got it! Just needed a GROUP BY:[sql]SELECT news.id AS newsid, COUNT(*) AS count
FROM post AS post, pchm_news AS news
WHERE post.threadid = news.forumid
GROUP BY news.id LIMIT 0,30[/sql]