--- In php-list@yahoogroups.com, <[EMAIL PROTECTED]> wrote: > > ----- Original Message ----- > From: "whoisquilty" > > I'm getting an error in my syntax. I've looked over my code multiple times > but it's just not > happening. Can anyone offer any advice? > > <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()); > > > Thank you! > > Jeremy > > > ------------------------------------ > Hello Jeremy, > It would be much easier if you told us the error message > and line number. Then we can just paste the code into our editors and see > the problem without having to upload it to a server for testing. > > Anyway, just a guess - look at your line in the query - > nodiscs = $nodiscs, > Shoud this be - > nodiscs = '$nodiscs', ?? > > And this - > WHERE discsetid = $var"; > > Hope this helps, Rob. >
Rob - Here is the error code that I'm getting. Unfortunately, I've added the ' ' around $nodiscs and it is still giving me the same 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 Any ideas? Jeremy
