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
awi shekh albaity [mailto:[EMAIL PROTECTED]
Sent: Saturday, March 01, 2003 12:27 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Update errors
What wrong with this SQL
$SQLSTATEMENT["UPDATE_CAT"] = "
UPDATE cats SET
cat_name = '$cat_name',
WHERE cat_id = $catidforedit
&qu
Remove the comma at the end of this line:
> cat_name = '$cat_name',//remove this comma
> -Original Message-
> From: Alawi shekh albaity [mailto:[EMAIL PROTECTED]
> Sent: Saturday, March 01, 2003 1:27 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] Update er
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.ne
