Member Avatar for Sorcher

I am trying to update a mysql entry.
Getting this error;

Insert 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 '('loginid='15',title='Test',author='Sorcher',body='
Yeah just testing this aga' at line 1
if ($_GET['edit']){
		$getedit = $_GET['edit'];
		$result=mysql_query("UPDATE articles SET ('loginid='$loginid',title='$title',author='$author',body='$body',date='$today',category='$category') WHERE articleid='$getedit' LIMIT 1")
or die("Insert Error: ".mysql_error());
mysql_close($link);
echo "Success!<br><a href='../article.php'>View the list!</a>";
exit();
}else
Edited by Sorcher because: n/a
  • 2 Contributors
  • 2 Replies
  • 89 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by Sorcher
Member Avatar for thejimgaudet 
$result=mysql_query("UPDATE articles SET loginid='$loginid',title='$title',author='$author',body='$body',date='$today',category='$category' WHERE articleid='$getedit' LIMIT 1")

Just use this, you had an extra ) that you didn't need...

Member Avatar for Sorcher

Damn, thanks. Silly me :O

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.