WHILE-loop initiation
IF ($candy_demand_new_offer > $candy_supply_most_recent_row)
{
$candy_demand_new_offer = $candy_demand_new_offer - $candy_supply_most_recent_row;
DELETE $candy_supply_most_recent_row;
INSERT $candy_demand_new_offer;
}

while ($candies_needed > 0 && $row = fetch) {
    if ($candies_needed >= $row['candies_available']) {
        $candies_needed -= $row['candies_available'];
        DELETE this row from inventory table;
    } else {
        UPDATE this row in inventory table SET candies_available = candies_available - $candies_needed;
        $candies_needed = 0;
    }
}
if ($candies_needed > 0) { // Haven't fullfilled the entire order
    INSERT $candies_needed into order table;
}