Loop

[NZ_Kiwi]

I have this code

<?php
$i = 1; 
while($i <= $number_game) { 

$result = mysql_query ("INSERT INTO results_data (`result_id`,`group_id`,`comp_run_id`,`team1_id`,`team2_id`,`game_played`,`team1_score`,`team2_score`,`list_order`,`weekday`) Values ('','$group_id','$comp_run_id','$team1_id','$team2_id','$game_played','$team1_score','$team2_score','$i','$weekday')") or die("INSERT error: ".mysql_error()); 

$t++;
}
?>

it just loops over and over and over.... any ideas why... i set $number_game to say 6!!! but it still goes over and over and over

[planetsim]

you have $t instead of $i

[NZ_Kiwi]

Originally posted by planetsim
you have $t instead of $i

Okay sorry didn't see that!!!

Next issue...
I have a drop down menu which i'm looping hence the fact i have the $i++ thing...

everytime i loop it the drop down menu gets a new name team1_id2, 3, 4, 5

So do i add [$i] to my code.. or how do i change it for every time it loops?

$i = 1; 
while($i <= $number_game) { 

$result = mysql_query ("INSERT INTO results_data (`result_id`,`group_id`,`comp_run_id`,`team1_id`,`team2_id`,`game_played`,`team1_score`,`team2_score`,`list_order`,`weekday`) Values ('','$group_id','$comp_run_id','$team1_id[$i]','$team2_id[$i]','$game_played','$team1_score','$team2_score','$i','$weekday')") or die("INSERT error: ".mysql_error()); 

$i++;
}

[robert_w_ark]

Originally posted by NZ_Kiwi
Okay sorry didn't see that!!!

Next issue...
I have a drop down menu which i'm looping hence the fact i have the $i++ thing...

everytime i loop it the drop down menu gets a new name team1_id2, 3, 4, 5

So do i add [$i] to my code.. or how do i change it for every time it loops?

$i = 1; 
while($i <= $number_game) { 

$result = mysql_query ("INSERT INTO results_data (`result_id`,`group_id`,`comp_run_id`,`team1_id`,`team2_id`,`game_played`,`team1_score`,`team2_score`,`list_order`,`weekday`) Values ('','$group_id','$comp_run_id','$team1_id[$i]','$team2_id[$i]','$game_played','$team1_score','$team2_score','$i','$weekday')") or die("INSERT error: ".mysql_error()); 

$i++;
}

[/B]

Hmm..Try this

for($i = 0;$i < 6;$i++)
{ 
  $result = mysql_query("INSERT INTO results_data  (result_id, group_id, comp_run_id, team1_id , team2_id, game_played, team1_score, team2_score, list_order, weekday) VALUES ('','$group_id','$comp_run_id','$team1_id[$i]','$t eam2_id[$i]','$game_played','$team1_score','$team2_score','$i','$weekday')") or die(mysql_error()); 
  $i++;
}

/*
Make sure these variables have data also..
$group_id
$comp_run_id
$team1_id
$t eam2_id
$game_played
$team1_score
$team2_score
$weekday
*/

Have fun 🙂

[NZ_Kiwi]

I've done this but it does not work

I just get 0 in my database....

for ($i = 0; $i < $number_game; $i++)
{
$result = mysql_query ("INSERT INTO results_data (`result_id`,`group_id`,`comp_run_id`,`team1_id`,`team2_id`,`game_played`,`team1_score`,`team2_score`,`list_order`,`weekday`) Values ('','$group_id','$comp_run_id','$team1_id[$i]','$team2_id[$i]','$game_played','$team1_score','$team2_score','$i','$weekday')") or die("INSERT error: ".mysql_error()); 
$i++;
}