Shouldn't have a comma after cat_name = '$cat_name'  unless you are updating
multiple fields.


Gary Every
Sr. UNIX Administrator
Ingram Entertainment
(615) 287-4876
"Pay It Forward"
mailto:[EMAIL PROTECTED]
http://accessingram.com


-----Original Message-----
From: Alawi shekh albaity [mailto:[EMAIL PROTECTED]
Sent: Saturday, March 01, 2003 12:27 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] 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

Reply via email to