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: 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
