RE: [PHP-DB] Update errors
| From: | Gary dot Every at ingramentertainment dot com | Date: | Thu, 27 Feb 2003 19:28:33 +0000 |
| Subject: | RE: [PHP-DB] Update errors | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-25974@lists.php.net to get a copy of this message | ||
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:gary.every@ingramentertainment.com
http://accessingram.com
-----Original Message-----
From: Alawi shekh albaity [mailto:alawi2002@php4web.com]
Sent: Saturday, March 01, 2003 12:27 AM
To: php-db@lists.php.net
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