--- whoisquilty <[EMAIL PROTECTED]> wrote: > This is what it says when I made the change to the code: > > UPDATE discset SET disc_title = 'General Release', studio = 'Sony Pictures', > country = 'USA', region = 'A', release = '2008-03-16', nodiscs = '2', > upc = '0908877661234', daterevised = '2008-03-21 20:19:18' > WHERE discsetid = 100000000 > 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 > 'release = '2008-03-16', nodiscs = '2', upc = '0908877661234', datere' > at line 6 > > It's either region or release. The 'A' shouldn't be a problem. It looks like > it's the date. Why would that be giving problems? > > Jeremy
It is likely a case where "release" is a MySQL keyword (whether used or not). Try placing it in back ticks (often on the keyboard in the upper left on the same key as the tilde): `release` = 'value' Backticks around the field name and single quotes around the value. James
