I know i got this all screwed up but I got a table with data in it. Im trying to pull just certain fileds after pulling the matching array. What I want is the team names and final scores for each team if there is gameid present. Heres my code. Any help would be greatly appreciated.
$week1_query = "SELECT * FROM game_summary WHERE league_id=1 and week=1 and season=2005";
$week1_results = mysql_query($week1_query);
while($result=mysql_fetch_array($week1_results)){
$current_game_id = $result['game_id'];
$game_array[] = $current_game_id;
}
$game1=$game_array[0];
$game2=$game_array[1];
$game2=$game_array[2];
$game3=$game_array[3];
$game4=$game_array[4];
$game5=$game_array[5];
$game6=$game_array[6];
$game7=$game_array[7];
$game8=$game_array[8];
$game9=$game_array[9];
$game10=$game_array[10];
$game11=$game_array[11];
$game12=$game_array[12];
$game13=$game_array[13];
$game14=$game_array[14];
$game15=$game_array[15];
if ($game1 != ''){
$game1_away = $game1['away_team'];
$game1_away_score = $game1['away_final'];
$game1_home = $game1['home_team'];
$game1_home_score = $game1['home_final'];
$game1_recap = '../../images/20/recap';
}else{
$game1_away = $game1['away_team'];
$game1_away_score = "0";
$game1_home = $game1['home_team'];
$game1_home_score = "0";
$game1_recap = '../../images/20/due';
}
