error with WHERE

[yebaws]

could someone please explain this error. It's driving me nuts - I just can't see what's wrong with the query

SQL query:

UPDATE coursedescriptions SET coursenumber = '333',
coursetitle = 'ctitle 6 mod',
coursedescription = 'description 6',
instructor = 'sssssssssss',
courseoutline1 = 'ssdfrfccdeeeee',
courseoutline2 = '',
courseoutline3 = '',
courseoutline4 = '',
courseoutline5 = '',
courseoutline6 = '',
courseoutline7 = '',
courseoutline8 = '',
courseoutline9 = '',
courseoutline10 = '',
country = '',
refcode = '',
startday = '',
startmonth = '',
startyear = '',
courselength = '',
cost = '',
buylink = '',
WHERE id =5

MySQL said: Documentation
#1064 - 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 = 5' at line 1

 

[guelphdad]

the last comma before the WHERE clause is not needed.

 

[yebaws]

THANKS!!!!

You've no idea how much grief that comma has caused me!

 

[r937]

dangling commas are a lot easier to spot if you use the leading comma coding convention --

UPDATE coursedescriptions 
   SET coursenumber = '333'
     , coursetitle = 'ctitle 6 mod'
     , coursedescription = 'description 6'
     , instructor = 'sssssssssss'
     , courseoutline1 = 'ssdfrfccdeeeee'
     , courseoutline2 = ''
     , courseoutline3 = ''
     , courseoutline4 = ''
     , courseoutline5 = ''
     , courseoutline6 = ''
     , courseoutline7 = ''
     , courseoutline8 = ''
     , courseoutline9 = ''
     , courseoutline10 = ''
     , country = ''
     , refcode = ''
     , startday = ''
     , startmonth = ''
     , startyear = ''
     , courselength = ''
     , cost = ''
     , buylink = ''
     , 
 WHERE id =5

r937.com | rudy.ca