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"

-----Original Message-----
From: Alawi shekh albaity [mailto:[EMAIL PROTECTED]
Sent: Saturday, March 01, 2003 12:27 AM
Subject: [PHP-DB] Update errors

What wrong with this SQL
 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 (
To unsubscribe, visit:

Reply via email to