Does anyone know why this code would update my database two times instead of 1?

Gary

Hi all,
This is stumping me.

I have a snippet of code that is supposed to show a customers ticket numbers (performed in a loop) then update the two fields in my database one time.

I get the correct display of the ticket numbers for my test data.
table 3 is handled correctly as well. The update to table 2 is messed up though. If I bought 2 tickets, it will be updated showing that I bought 4 tickets...every test I've run, it's been twice the amount it should be.

Please help if you can.
BTW, no error messages on my php pages.

Thanks so much

<?
for ($i = 0; $i <= $quantity; $i++) {
//for testing ticket number value
print ("you bought ticket number $starting_ticket<br>");

$enter_tickets_query = "INSERT INTO $table3(user_id, item_id, ticket_number) VALUES (\"$user_id\", \"$item_id\", $starting_ticket\")";
$result = mysql_db_query($dbase, $enter_tickets_query, $con);
$starting_ticket++;

}

$tickets_remaining = $tickets_remaining - $quantity;
$update_item_query = "UPDATE $table2 SET tickets_remaining=\"$tickets_remaining\", starting_ticket=\"$starting_ticket\" WHERE item_id = \"$item_id\"";

$result = mysql_db_query($dbase, $update_item_query, $con);
?>

jerdo

One problem:

for ($i = 0; $i <= $quantity; $i++)

should be:

for ($i = 0; $i < $quantity; $i++)

Unless you start the count at $i = 1 then you can use the <=. As is your loop will execute one more time than it should.

Gary

Thank you for your reply.
I guess I'm still stumped. I'll give a scenario and describe what is happening.

I come to the site and decide to buy 2 tickets for item number 4.
I go through paypal ok...(skipping to ipn page)

For testing purposes, I have the script printing the ticket numbers I purchased (the for loop) and that section works fine. In this case the starting ticket number is 4000 and I see "You bought ticket number 4000, you bought ticket number 4001. That section seems ok in all appearances.

Then I look in table 4 where user_id, item_id, and starting_ticket are entered for each ticket purchased. That seems to work ok too...only 2 tickets entered...correct user_id, correct item_id, and correct ticket numbers.

The problem comes with the update data. All I want to do is update the starting_ticket and tickets_remaining fields. The update, however, somehow multiplies my data by 2 before updating...or updates twice, but it is not in a loop of any kind.

Please help 😉