help

[msnhockey]

hi all

here is my code below for trying to call a schedule between 2 teams. I have a next game feaure which brings up the next game and am trying to use this code below to get the previous games played between the teams playing next.

The code below lists 5 games of one team vrs all teams.

any ideas or help is appriciated

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

      ."(team1 = '".$id."' AND team2 = '".$id."') OR (team2 = '".$id."' OR team1 = '".$id."') "

    ."AND season = '$sid' "

    ."AND team1_score > ' ' "

    ."AND team2_score > ' ' "

."ORDER BY date DESC LIMIT 5");

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

$schedule = ("
	<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\">
              <tr>
              <td bgcolor=\"#000000\">
                        <table width=\"100%\" border=0 cellspacing=1 cellpadding=2>\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");

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

    //ROW COLOR
    $tbgcolor = is_int($i_ss / 2)?"#ffffff":"#EFEFEF";

    $schedule .= "
	<tr bgcolor=\"".$tbgcolor."\" align=\"center\">";

	if($team1_score == "" && $team2_score == "") {
		    $schedule .= "
	                  <td class=\"table_text\" align=center>".$ndate."</td>";
	    } else {
	        $schedule .= "
		                <td class=\"table_text\" align=center><b><a href=\"".$sport_dir."inc/showgame.php?id=".$ssid."&tdiv=".$divisionname."\" onClick=\"NewWindow(this.href,'name','700','600','yes');return false;\">
				         ".$ndate."</a></b></td>";
}
            $schedule .= "
            <td class=\"table_text\">".$team1."</td>";
     if($team1_score > $team2_score) {
            $schedule .="
            <td class=\"table_text\" align=center>";
            	if($gm_ot == 1) {
            	$schedule .= "<b><u>".$team1_score."</u></b></td>";
            	} else {
            	$schedule .= "".$team1_score."</td>";
            	}
     } else {
            	if($gm_ot == 1) {
            	$schedule .= "<td class=\"table_text\" align=center><b><u>".$team1_score."</u></b></td>";
            	} else {
            	$schedule .= "<td class=\"table_text\" align=center>".$team1_score."</td>";
            	}
     }

        if($team2_score > $team1_score) {
	    $schedule .="
	    <td class=\"table_text\" align=center>";
            	if($gm_ot == 1) {
            	$schedule .= "<b><u>".$team2_score."</u></b></td>";
            	} else {
            	$schedule .= "".$team2_score."</td>";
            	}
	} else {
            	if($gm_ot == 1) {
            	$schedule .= "<td class=\"table_text\" align=center><b><u>".$team2_score."</u></b></td>";
            	} else {
            	$schedule .= "<td class=\"table_text\" align=center>".$team2_score."</td>";
            	}
        }
            $schedule .= "<td class=\"table_text\">".$team2."</td></tr>";

            $i_ss++;
   }

   $schedule .= "

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

here is the code for the next game

//NEXT GAME TO BE PLAYED

$result_schedules_scores1 = mysql_query("SELECT * FROM schedule_scores WHERE "

."(team1 = '$id' OR team2 = '$id') "

."AND season = '$sid' "

    ."AND team1_score > ' ' "

    ."AND team2_score > ' ' "

."ORDER BY date LIMIT 1");



$team11 = mysql_result($result_schedules_scores,$i,"team1"); 
$team22 = mysql_result($result_schedules_scores,$i,"team2"); 
$sql_team11_name = mysql_query("SELECT name FROM teams WHERE id = '$team11'"); 
$team11name = mysql_result($sql_team11_name,"name"); 
$sql_team22_name = mysql_query("SELECT name FROM teams WHERE id = '$team22'"); 
$team22name = mysql_result($sql_team22_name,"name"); 



$team11pic = mysql_result($result_schedules_scores1,0,"team1pic");

$team22pic= mysql_result($result_schedules_scores1,0,"team2pic");