sql update on compound key

[Cabbit]

// Instert a frech product to the order
		$result = mysql_query("UPDATE `Order Items`  SET `Qty`=`Qty`+1 WHERE `ProductID` = '$productid'");
		if (mysql_affected_rows()==0) 
		{
			$result = mysql_query("INSERT INTO `Order Items` (`OrderNumber`,`ProductID`,`Qty`) VALUES 
				('$ordernumber','$productid','1')");
		}

This has been buging me till daylight, how do i get it to update if a record is already found with a compound key or ProductID and OrderNumber?

 

[savar]

// Instert a frech product to the order
		$result = mysql_query("UPDATE `Order Items`  SET `Qty`=`Qty`+1 WHERE `ProductID` = '$productid'");
		if (mysql_affected_rows()==0) 
		{
			$result = mysql_query("INSERT INTO `Order Items` (`OrderNumber`,`ProductID`,`Qty`) VALUES 
				('$ordernumber','$productid','1')");
		}

This has been buging me till daylight, how do i get it to update if a record is already found with a compound key or ProductID and OrderNumber?

Not fully sure I understand, but this might be what you're looking for: http://dev.mysql.com/doc/refman/5.0/en/insert-on-duplicate.html

 

[Cabbit]

No ON DUPLICATE KEY does not function with a compound key.

 

[Cabbit]

I got it, i forgot to add a AND so that it was checking against both keys.