Loop Adding to SQL

[NZ_Kiwi]

I have this code.... should this work okay???
for some reason it's not working... I have a db link but i've removed it to post it on this site... $number_game like all other variables are from another page!

<?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++;
}
?>

[Frederick]

Nope, will not work. WHILE should be

if ($i <= $number_game) {
// code
}