[Resolved] SQL Adding Problem

[NZ_Kiwi]

This is a section of my code, now team1_id and team2_id are looped and everytime they get a new number such as team1_id1 then 2 then 3 ect ect

What i'm wanting to do is to loop my insert command so it adds them all.. this is what i've made but it does not work... i just get 0 in the 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++;
}

[eoghain]

I've never been able to get arrays to convert properly inside of quotes, try this:

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