SQL syntax Error on UPDATE query

TwiztedFake · 10-20-2006, 07: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); 

????: NamePros.com http://www.namepros.com/programming/249124-sql-syntax-error-on-update-query.html

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, 04:22 PM

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

10-20-2006, 07:50 AM	THREAD STARTER #1 (permalink)
TwiztedFake NamePros Regular Join Date: Apr 2004 Location: IL Posts: 348	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); ????: NamePros.com http://www.namepros.com/programming/249124-sql-syntax-error-on-update-query.html` 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. __________________ -TwiztedFake- RTard Tutorials Digital-Dummy to Total-Techie Last edited by TwiztedFake; 10-20-2006 at 08:04 AM.

10-24-2006, 04:22 PM	#2 (permalink)
PoorDoggie Soon to be RICHdoggie! Join Date: Jan 2005 Location: UK Posts: 2,408	heh... i always post problems and then figure them out straight away! lol

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