RE: [PHP-DB] Update errors
| From: | Hutchins, Richard | Date: | Thu, 27 Feb 2003 19:23:04 +0000 |
| Subject: | RE: [PHP-DB] Update errors | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-25973@lists.php.net to get a copy of this message | ||
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: [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
>