hey all,

this code I have below works, except when I try to put onto my team page.

I am trying to use 2 tables from my db..
schedule_scores which is game info &
player_stats which is game stats for each game.

I want to insert this into my previous games box showing just the goal scorers for each team in the previous game box.....I have been trying everything to get this to work. I am certain it is having to do with the ID's associated with each. ie the game id's.

I will also include the previous game code so whomever can have a better idea.

any help appricated

$result_gm = mysql_query("SELECT * FROM schedule_scores WHERE id = '$ssid'");





$gm_team1 = mysql_result($result_gm,0,"team1");
				if(eregi("l-",$gm_team1)) {
$gm_team1 = eregi_replace("l-","",$gm_team1);
$result_t1 = mysql_query("SELECT * FROM locations WHERE id = '".$gm_team1."'");
$t1_name = mysql_result($result_t1,0,"name");
				} else {
$result_t1 = mysql_query("SELECT * FROM teams WHERE id = '".$gm_team1."'");
$t1_name = mysql_result($result_t1,0,"name");
				}

//PLAYER STATS FOR VISITOR TEAM
$result_pi = mysql_query("SELECT * FROM players WHERE teamid = '".$gm_team1."' AND registered = '1' ORDER BY lname");

$total_pi = mysql_numrows($result_pi);
$i = 0;


        while($i < $total_pi) {

                //ROW COLOR
		$pid = mysql_result($result_pi,$i,"id");

            	//GET STAT INFO
		$result_ps = mysql_query("SELECT * FROM player_stats WHERE playerid = '".$pid."' AND game_id = '$ssid' AND goals > '0'");
		$total_ps = mysql_numrows($result_ps);

		if($total_ps > 0) {
			$goals = mysql_result($result_ps,0,"goals");

		} else {
                            $goals = "0";

		}
                     if($goals > 1) {
		$stats12 .= "

".mysql_result($result_pi,$i,"fint")." ".mysql_result($result_pi,$i,"lname")."
	              "; 
	                $stats12 .= " ($goals),&nbsp; </td> ";
                       } elseif($goals > 0) {
	              $stats12 .= "

".mysql_result($result_pi,$i,"fint")." ".mysql_result($result_pi,$i,"lname").",&nbsp;
	              "; 

                       }


			   $i++;
		unset($result_ps);
        }

here is the previous game code

//PREVIOUS GAME PLAYED
$i = 0;
$result1_schedules_scores = mysql_query("SELECT * FROM schedule_scores WHERE "

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

."AND season = '$sid' "

    ."AND team1_score > '-' "

."ORDER BY date DESC, time DESC  LIMIT 1");

$ssid = mysql_result($result1_schedules_scores,0,"id");       

$team1 = mysql_result($result1_schedules_scores,$i,"team1"); 
$team2 = mysql_result($result1_schedules_scores,$i,"team2"); 
$sql_team1_name = mysql_query("SELECT name FROM teams WHERE id = '$team1'"); 
$teamname1 = mysql_result($sql_team1_name,"name"); 
$sql_team2_name = mysql_query("SELECT name FROM teams WHERE id = '$team2'"); 
$teamname2 = mysql_result($sql_team2_name,"name"); 
$schedules_scores_date = mysql_result($result1_schedules_scores,$i,"date"); 
$schedules_scores_location = mysql_result($result1_schedules_scores,$i,"location"); 
$schedules_scores_team1 = mysql_result($result1_schedules_scores,$i,"team1"); 
$schedules_scores_team2 = mysql_result($result1_schedules_scores,$i,"team2"); 
$schedules_scores_team1score = mysql_result($result1_schedules_scores,$i,"team1_score");    

$schedules_scores_team2score = mysql_result($result1_schedules_scores,$i,"team2_score");
$team1_id = mysql_result($result1_schedules_scores,$i,"team1");
$team2_id = mysql_result($result1_schedules_scores,$i,"team2"); 
$t1_div = mysql_result($result1_schedules_scores,$i,"team1_div");
$t2_div = mysql_result($result1_schedules_scores,$i,"team2_div"); 
$gm_team2 = mysql_result($result1_schedules_scores,0,"team2");
$team1pic = mysql_result($result1_schedules_scores,0,"team1pic");
$team2pic = mysql_result($result1_schedules_scores,0,"team2pic");

    never mind I changed some code around and got it

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

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

."AND season = '$sid' "

    ."AND team1_score > '-' "

."ORDER BY date DESC, time DESC  LIMIT 1");

$gameid = mysql_result($homegoals1,0,"id");       
    
$gm_team2 = mysql_result($homegoals1,0,"team1");
$result_t2 = mysql_query("SELECT * FROM teams WHERE id = '".$gm_team2."'");
$t2_name = mysql_result($result_t2,0,"name");

$result_pi = mysql_query("SELECT * FROM players WHERE teamid = '".$gm_team2."' AND registered = '1' ORDER BY lname");
$total_pi = mysql_numrows($result_pi);
$i = 0;

        while($i < $total_pi) {

$pid = mysql_result($result_pi,$i,"id");

$result_ps = mysql_query("SELECT * FROM player_stats WHERE playerid = '".$pid."' AND game_id = '$gameid' AND goals > '0'");
$total_ps = mysql_numrows($result_ps);

		if($total_ps > 0) {
			$goals = mysql_result($result_ps,0,"goals");

		} else {
                            $goals = "0";

		}
                     if($goals > 1) {
		$stats13 .= "

".mysql_result($result_pi,$i,"fint")." ".mysql_result($result_pi,$i,"lname")."
	              "; 
	                $stats13 .= " ($goals),&nbsp; </td> ";
                       } elseif($goals > 0) {
	              $stats13 .= "

".mysql_result($result_pi,$i,"fint")." ".mysql_result($result_pi,$i,"lname").",&nbsp;
	              "; 

                       }


			   $i++;
		unset($result_ps);
        }
      Write a Reply...