--- In php-list@yahoogroups.com, James Keeline <[EMAIL PROTECTED]> wrote: > > --- 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 >
That was it! Thank you, James. I wonder why MySQL would let me create a row with that name if it's a keyword.
