Remove the comma at the end of this line: > cat_name = '$cat_name',//remove this comma > -----Original Message----- > From: Alawi shekh albaity [mailto:alawi2002@php4web.com] > Sent: Saturday, March 01, 2003 1:27 AM > To: php-db@lists.php.net > Subject: Update errors > > > What wrong with this SQL > $SQLSTATEMENT["UPDATE_CAT"] = " > UPDATE cats SET > cat_name = '$cat_name', > WHERE cat_id = $catidforedit > "; > Error no : 1064 > Details : > > You have an error in your SQL syntax near 'WHERE cat_id = 2 ' > at line 4 > > Db : mysql > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
