[MissKalunji]

database error

Invalid SQL:

      UPDATE itemshop_stock
      SET iorder =
          CASE
                       WHEN uid = 8 THEN
                       WHEN uid = 9 THEN
                       WHEN uid = 11 THEN
                       WHEN uid = 19 THEN
                       WHEN uid = 21 THEN
                       WHEN uid = 31 THEN
                       WHEN uid = 50 THEN
                       WHEN uid = 69 THEN
                       WHEN uid = 75 THEN
                       WHEN uid = 76 THEN
                       WHEN uid = 88 THEN 1
              ELSE uid
          END
      WHERE uid IN (8,9,11,19,21,31,50,69,75,76,88);

MySQL 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 'WHEN uid = 9 THEN
                       WHEN uid = 11 THEN
                       WHEN uid = 19 THEN
Error Number : 1064
Date         : Sunday, May 6th 2007 @ 11:51:21 AM
Script       : http://www.dancehallareaz.com/forum/ishop.php?do=doupdateorder