[RESOLVED] Database not updating and mysql_error() returns nothing

[middleman666]

Hi All,

I have these two UPDATE queries:

mysql_query("UPDATE merch SET UnSold = UnSold + $diff WHERE id = $MerchID") or die(mysql_error());
mysql_query("UPDATE cart SET qty = $newQty WHERE id = $CartID") or die(mysql_error());

Echoed, I get:
UPDATE merch SET UnSold = UnSold + 1 WHERE id = 1
UPDATE cart SET qty = 4 WHERE id = 18423

Putting those into phpymadmin updates the entries fine, but it just doesn't seem to be working in the code. I have loads of other similar queries that work fine.

The or die function doesn't seem to report anything back.

Any ideas?

Thanks

[middleman666]

Maybe it'll help if I let you see where the code is with the rest of it:

	//Minus $rep from ForceGrouping promotions in cart and replen $rep to merch
	$Presult = mysql_query("SELECT * FROM promotions WHERE TicketID = {$productId[$i]} AND ForceGrouping = 'yes'");
	if (mysql_num_rows($Presult) != 0) {
		while($Prow = mysql_fetch_array($Presult)) {
			$DescID = $Prow['DescID'];
			$MerchID = $Prow['MerchID'];

		if ($DescID > 0) {
			//Replen $rep to merch from cart with that DescID
			$Mresult = mysql_query("SELECT * FROM merch WHERE DescID = $DescID");
			while ($Mrow = mysql_fetch_array($Mresult)) {	
				$MerchID = $Mrow['id'];	
				//Is the linked product in the cart?
				$Cresult = mysql_query("SELECT * FROM cart WHERE productID = $MerchID AND productType = 'M' AND sessionID = '$DSessionID'");
				if (mysql_num_rows($Cresult) != 0) {
					$Crow = mysql_fetch_array($Cresult);
					$CartQty = $Crow['qty'];
					$CartID = $Crow['id'];
					//Does the linked product have more CartQty than the new Ticket quantity?
					if ($CartQty > $newQty) {
						//Find difference
						$diff = $CartQty - $newQty; 
						if ($diff <= 0) {
							//If difference is less of equal to zero, delete product from cart
							deleteFromCart($CartID);	
							$numDeleted += 1;												
						}
						else {
							echo '('.$MerchID.')'.$CartQty.'-'.$newQty.' ['.$diff.']| ';
							mysql_query("UPDATE merch SET UnSold = UnSold + $diff WHERE id = $MerchID") or die(mysql_error());
							mysql_query("UPDATE cart SET qty = $newQty WHERE id = $CartID") or die(mysql_error());
						}
					}
				}
			}
		}
		else if ($MerchID > 0) {
			//Is the linked product in the cart?
			$Cresult = mysql_query("SELECT * FROM cart WHERE productID = $MerchID AND productType = 'M' AND sessionID = '$DSessionID'");
			if (mysql_num_rows($Cresult) != 0) {
				$Crow = mysql_fetch_array($Cresult);
				$CartQty = $Crow['qty'];
				$CartID = $Crow['id'];
				//Does the linked product have more CartQty than the new Ticket quantity?
				if ($CartQty > $newQty) {
					//Find difference
					$diff = $CartQty - $newQty; 
					if ($diff <= 0) {
						//If difference is less of equal to zero, delete product from cart
						deleteFromCart($CartID);	
						$numDeleted += 1;												
					}
					else {
						mysql_query("UPDATE merch SET UnSold = UnSold + $diff WHERE id = $MerchID");
						mysql_query("UPDATE cart SET qty = $newQty WHERE id = $CartID");
					}
				}
			}						
		}

	}
}

I know it gets to the queries because this line is echo'd:
echo '('.$MerchID.')'.$CartQty.'-'.$newQty.' ['.$diff.']| ';

This is driving me mental :/

[middleman666]

Nevermind, looks like I was posting a value earlier in the code which was re-updating the table after updating it... idiot.