PHP Update query not working

[sharky92663]

Hello,

I'm using a standard update query and getting an error message.

Here is the code:

if ((isset($HTTP_POST_VARS["MM_update"])) && ($HTTP_POST_VARS["MM_update"] ==
"updateQty")) {
$updateSQL = sprintf("UPDATE cart SET qty=%s, WHERE cartId=%s",
GetSQLValueString($HTTP_POST_VARS['qty'], "int"),
GetSQLValueString($HTTP_POST_VARS['cartId'], "int"));

mysql_select_db($database_connMobis, $connMobis);
$Result1 = mysql_query($updateSQL, $connMobis) or die(mysql_error());

Here is the error:

You have an error in your SQL syntax. Check the manual that corresponds to
your MySQL server version for the right syntax to use near 'WHERE cartId=183'
at line 1


I've been pulling my hair over this because it's so straighforward and I've
used this query hundreds to times before. If you notice anything, please let
me know.

Jim

[David Powers]

sharky92663 wrote:

> $updateSQL = sprintf("UPDATE cart SET qty=%s, WHERE cartId=%s",

> I've been pulling my hair over this because it's so straighforward and I've
> used this query hundreds to times before.

I would be very surprised if you have used this query hundreds of times
before without getting the same mistake. There should be no comma before
WHERE:

$updateSQL = sprintf("UPDATE cart SET qty=%s WHERE cartId=%s",

--
David Powers
Author, "Foundation PHP 5 for Flash" (friends of ED)
Co-author "PHP Web Development with DW MX 2004" (Apress)
[url]http://computerbookshelf.com[/url]