Re: Update errors
| From: | Jason Wong | Date: | Fri, 28 Feb 2003 05:39:25 +0000 |
| Subject: | Re: Update errors | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-25991@lists.php.net to get a copy of this message | ||
On Saturday 01 March 2003 14:27, Alawi shekh albaity wrote:
> What wrong with this SQL
> $SQLSTATEMENT["UPDATE_CAT"] = "
> UPDATE cats SET
> cat_name = '$cat_name',
Remove that trailing comma.
> 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
--
Jason Wong -> Gremlins Associates -> www.gremlins.biz
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
------------------------------------------
Search the list archives before you post
http://marc.theaimsgroup.com/?l=php-db
------------------------------------------
/*
Massachusetts has the best politicians money can buy.
*/