hi..
this query works fine when calling previous games played between 2 teams..
$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");
what i need this code to do is call previous scores which it does, but for teams that are getting ready to play..
i use this code to call that
$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");
so basically if say
Halifax's next game is against Toronto then all the games played prior in the season will show and if no previous games were played between them. then
No Games Played will appear
thanks