SQL syntax Error on UPDATE query

TwiztedFake · 10-20-2006, 06:50 AM

The error is:
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 '(date, time, uname, subject, content) VALUES ('10-20-2006', '6:

My code is:

PHP Code:

  $sql = "UPDATE ct_news SET (date, time, uname, subject, content) VALUES ('$date', '$time', '$uname', '$subject', '$content') WHERE ID='$id' LIMIT 1";

$result = mysql_query($sql);

How did I write this so that it updates the table row with the new data.

**UPDATE**
Geez. . . 2nd problem I've posted this week that I got figured out within 10 minutes of posting it.

Changed the $sql= line to:

PHP Code:

  $sql = "UPDATE ct_news SET date = '$date', time = '$time', uname = '$uname', subject = '$subject', content = '$content' WHERE ID = '$id' LIMIT 1";

Now it works! I tried that once but I guess I most have had something in the wrong place.

PoorDoggie · 10-24-2006, 03:22 PM

heh... i always post problems and then figure them out straight away! lol

10-20-2006, 06:50 AM	#1 (permalink)
TwiztedFake NamePros Regular Join Date: Apr 2004 Location: IL Posts: 339 50.00 NP$ (Donate)	SQL syntax Error on UPDATE query The error is: 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 '(date, time, uname, subject, content) VALUES ('10-20-2006', '6: My code is: PHP Code: `$sql = "UPDATE ct_news SET (date, time, uname, subject, content) VALUES ('$date', '$time', '$uname', '$subject', '$content') WHERE ID='$id' LIMIT 1"; $result = mysql_query($sql);` How did I write this so that it updates the table row with the new data. UPDATE Geez. . . 2nd problem I've posted this week that I got figured out within 10 minutes of posting it. Changed the $sql= line to: PHP Code: `$sql = "UPDATE ct_news SET date = '$date', time = '$time', uname = '$uname', subject = '$subject', content = '$content' WHERE ID = '$id' LIMIT 1";` Now it works! I tried that once but I guess I most have had something in the wrong place. __________________ Four Seasons Outfitters [ 25 $NP/Month ] [ 25 $NP/Month ] [ 25 $NP/Month ] [ 25 $NP/Month] [ 25 $NP/Month] Last edited by TwiztedFake; 10-20-2006 at 07:04 AM.

10-24-2006, 03:22 PM	#2 (permalink)
PoorDoggie Soon to be RICHdoggie! Join Date: Jan 2005 Location: UK Posts: 2,390 316.50 NP$ (Donate)	heh... i always post problems and then figure them out straight away! lol __________________ █ Exchange your long URL for a much smaller one! █ Free Anonymizer/Proxy █ Taz Martin's blog - Learn all about internet marketing, promoting your website and much more!

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)