--- In php-list@yahoogroups.com, William Piper <[EMAIL PROTECTED]> wrote:
>
> whoisquilty wrote" "On 3/20/2008 10:10 PM":"
> > > <snip>
> > >
> > > $query = "UPDATE discset
> > > SET disc_title = '$disc_title',
> > > studio = '$studio',
> > > country = '$country',
> > > region = '$region',
> > > release = '$release',
> > > nodiscs = $nodiscs,
> > > upc = '$upc',
> > > daterevised = '$updated'
> > > WHERE discsetid = $var";
> > > $result = mysql_query($query) or die(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 'release = '2008-03-16',
> > nodiscs = 2, upc
> > = '0908877661234', daterevi' at line 6
> >
>
> Change the "or die()" to this below and rerun and send us the output.
> or die("$query\n".mysql_error());
>
> bp
>
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
