updating mySQL with array problem

[Anon]

Trying to update mySQL db with the following code but it will only update the last array each time.
Can you see a problem with the code?

foreach($array as $val)
{
$sql = " UPDATE cart SET
quantity='$val'
WHERE cartid = '$cartid' && productid = '$id'";
mysql_query($sql) or die("Cannot update the database.<br>" . mysql_error());
}

Thanks :-)

-Dizzy

[lenhewitt]

That looks as though you are NOT changing the productid, so each field of the array will be written to the same datatabas record as it is being identified by the same productid for each:

foreach($array as $val)