calling from db

[msnhockey]

hi all,

i am trying to call games from a database that would include 2 teams.

on my teams page I have a next game feature which works fine, but below that I want to display all games those 2 teams played prior to that game during the season.

any ideas??

[NogDog]

Pretty hard to tell without knowing something about the database schema. If it comes from one table that has the teams as 2 different columns, you might have to do something like:

$query = "SELECT * FROM games WHERE 
(team1 = $teamA AND team2 = $teamB) OR (team1 = $teamB AND team2 = $teamA)";

[msnhockey]

here is the code I use for getting 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");