- - - - - - - -
Is it possible to retrieve values set by an Update statement?
For example...
Code: Select all
$query = "UPDATE inventory_main SET inventoryNumber = inventoryNumber + 1 WHERE inventoryId = 7";
$dbResults = $db->query($query);- - - - - - - -
I did write some code that I believe will work and prevent race conditions, but there probably is a much simpler way to go about this.
$success = false;
Code: Select all
while(!$success){
$query = "SELECT inventoryNumber FROM inventory_main WHERE inventoryId = 7";
$dbResults = $db->query($query);
$row = $dbResults->fetch_assoc();
echo "Inventory Number: ".$row['inventoryNumber']."<br />";
$newFieldValue = $row['inventoryNumber'] + 1;
echo "Attempt: ";
$query = "UPDATE inventory_main SET inventoryNumber = IF (inventoryNumber = ".$row['inventoryNumber'].", inventoryNumber + 1, inventoryNumber) WHERE inventoryId = 7 LIMIT 1";
$dbResults = $db->query($query);
if($db->affected_rows == 1) $success = true;
}