<?php # Script  - view_duals.inc
// This script retrieves and dispalys dual meet results for a specified season.

$page_title = 'View Season Team Rankings';

require_once ('mysql_connect.php'); // Connect to the db.

function show_season_teams($season) {

        $report_title ='Team Rankings for ' . $season;

        $query_duals ="SELECT rank_date, School
                        FROM rankings_school INNER JOIN schools ON rankings_school.School_id = schools.School_id
                        WHERE (rank=1) AND (season=" . $season . ")
                        ORDER BY rank_date";

        $result_duals = @mysql_query ($query_duals); // Run the dual meet query.

        if ($result_duals) { // If it ran OK, display the records.
            echo '<table border="1" align="center" style="border-collapse: collapse" cellspacing="1" cellpadding="3" bordercolor="#111111" bgcolor="#FFFFFF">
                <caption><font face="Arial" size="3" color="#FFFFFF"><b>' . $report_title . '</b><br>Click on Date for Rankings</font></caption>
                <tr><td align="center" bgcolor="#C0C0C0"><b>Date</b></td>
                <td align="center" bgcolor="#C0C0C0"><b>Team Ranked #1</b></td>';
            while ($row = mysql_fetch_array($result_duals, MYSQL_NUM)) {
                echo "<tr>
                <td align=\"left\"><a href='view_school_rankings.php?date=" . $row[0] . "'>"  . $row[0] . "</a></td>
                <td align=\"left\">$row[1]</td></tr>\n";
                }
            echo '</table><p></p>';
        }
        mysql_free_result ($result_duals); // Free up the resources.
}
?>
