Coding help

[msnhockey]

this code does execute but not to what i am looking for.
on my hockey team pages i have a thing for previous games played and next game to be played.

the code below is t show previous results in the next game to be played box.
instead it shows the games of the previous games played

is there something in here i am missing?
any help is appriciated. even guidance to the right direction

thanks

			<tr>

			<th nowrap bgcolor=\"#DFDFDF\">

			<span style=\"font-variant: small-caps; text-transform: capitalize\">

			previous results</span></th>

		</tr>

		<tr>

			<td align=\"center\" bgcolor=\"#EEEEEE\"><!--%STATS7%--> </a></td>

		</tr>

	</table>

	</td>

</tr>

</table>																

								</td>

							</tr>

";
$result_ss = mysql_query("SELECT * FROM schedule_scores WHERE "

."((team1={$team1} and team2={$team2}) or (team1={$team2} and team2={$team1}))  "
            ."AND season = '$sid' "
            ."AND team1_score > '' "
            ."AND team2_score > '' "
            ."ORDER BY date desc LIMIT 12");

$i_ss = 0;
$total_rows_ss = mysql_numrows($result_ss);

$schedule8 = ("
	<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\">
              <tr>
              <td bgcolor=\"#EEEEEE\">
                        <table width=\"100%\" border=0 cellspacing=1 cellpadding=0>\n");


while($i_ss < $total_rows_ss) {
        $ssid = mysql_result($result_ss,$i_ss,"id");
        $date = mysql_result($result_ss,$i_ss,"date");
        $time = mysql_result($result_ss,$i_ss,"time");
        $split_the_time = explode(":",$time);
	$time = date("g:ia", mktime($split_the_time[0], $split_the_time[1], 0));
        $location = mysql_result($result_ss,$i_ss,"location");
        $team1 = mysql_result($result_ss,$i_ss,"team1");
        $team2 = mysql_result($result_ss,$i_ss,"team2");
        $team1_score = mysql_result($result_ss,$i_ss,"team1_score");
        $team2_score = mysql_result($result_ss,$i_ss,"team2_score");
	$gm_ot = mysql_result($result_ss,$i_ss,"ot_game");

        $team1_id = $team1;
		$team2_id = $team2;

		$sql_team1_name = "SELECT name FROM teams WHERE id = '$team1'";
		$result_team1_name = mysql_query("$sql_team1_name");
		$team1 = mysql_result($result_team1_name,0,"name");
		$sql_team2_name = "SELECT name FROM teams WHERE id = '$team2'";
		$result_team2_name = mysql_query("$sql_team2_name");
		$team2 = mysql_result($result_team2_name,0,"name");
$t111_div = mysql_result($result_ss,$i_ss,"team1_div");
$t222_div = mysql_result($result_ss,$i_ss,"team2_div");


    //EDIT DATE
    $adate = explode("-",$date);
    $ndate = date ("M j", mktime (0,0,0,$adate[1],$adate[2],$adate[0]));

    //ROW COLOR
    $tbgcolor = is_int($i_ss / 2)?"#DFDFDF":"#EFEFEF";
     $schedule8 .= "
	<tr bgcolor=\"".$tbgcolor."\" align=\"center\">";

	if($team1_score == "" && $team2_score == "") {
		    $schedule8 .= "
	                  <td class=\"table_text8\" align=center>".$ndate."</td>";
	    } else {
	        $schedule8 .= "
		                <td class=\"table_text8\" align=center><b><a href=\"".$sport_dir."inc/showgame.php?id=".$ssid."\" onClick=\"NewWindow(this.href,'name','900','700','yes');return false;\">
				         ".$ndate."</a></b></td>";
}
            $schedule8 .= "
            <td class=\"table_text8\"><a href=\"./?opt=viewteam&id=$team1_id&divid=$t111_div&sid=$sid\">".$team1."</a></td>";
     if($team1_score > $team2_score) {

            $schedule8 .="
            <td class=\"table_text8\" align=center>";
            	if($gm_ot == 1) {
            	$schedule8 .= "<b><u>".$team1_score."</u></b></td>";
            	} else {
            	$schedule8 .= "".$team1_score."</td>";
            	}
     } else {
            	if($gm_ot == 1) {
            	$schedule8 .= "<td class=\"table_text8\" align=center><b><u>".$team1_score."</u></b></td>";
            	} else {
            	$schedule8 .= "<td class=\"table_text8\" align=center>".$team1_score."</td>";
            	}
     }

        if($team2_score > $team1_score) {
	    $schedule8 .="
	    <td class=\"table_text8\" align=center>";
            	if($gm_ot == 1) {
            	$schedule8 .= "<b><u>".$team2_score."</u></b></td>";
            	} else {
            	$schedule8 .= "".$team2_score."</td>";
            	}
	} else {
            	if($gm_ot == 1) {
            	$schedule8 .= "<td class=\"table_text8\" align=center><b><u>".$team2_score."</u></b></td>";
            	} else {
            	$schedule8 .= "<td class=\"table_text8\" align=center>".$team2_score."</td>";
            	}
        }
            $schedule8 .= "<td class=\"table_text8\"><a href=\"./?opt=viewteam&id=$team2_id&divid=$t222_div&sid=$sid\">".$team2."</a></td></tr>";

            $i_ss++;
   }

 if($i_ss == 0) {
                $schedule8 .= "<tr><td class='body_text' align='center' colspan='7'>-No Games Scheduled-</td></tr>";
        }


   $schedule8 .= "

              </tr></table></td></table>";