<?php
$link = mysql_connect('IG88', 'USER_ID', 'PASSWORD');
if (!$link) {
  die('Could not connect: ' . mysql_error());
}
mysql_select_db(racing);

$home_club = $_GET['home_club'];
$race_year = $_GET['race_year'];

$query = "select * from html where Home_Club = '$home_club'";

$result = mysql_query($query) 
  or die("Cannot execute query");
$row = mysql_fetch_assoc($result);
echo $row['Head'];
echo $row['Menu_Top'];
$tail = $row['Tail'];
?>

<!--
The menu is divided in 2 parts so additional menu items can be added. 
This would accomodate lower tier page menu item that you do not want 
on the main menu. Place the html for menu rows here.
-->

</table></td><td align="center" width="70%">

<?php
echo '<h2>Season Points for '.$race_year.'</h2>';
echo 'Note: You must be an I-5 member to received year-end awards<br>
Novice class races do not earn points<br><br>';
$driver_points = array();
$car_class = '';

$query = "select Results_Array, Race_ID, Race_Class from race where Type = 'Club Points' and
Race_Date like '$race_year%' and Results_Array IS NOT NULL order by Race_Class";
$result = mysql_query($query) 
    or die("Cannot execute select from race");
while($row = mysql_fetch_assoc($result)){
  $race_id = $row[Race_ID];
    if (($car_class != $row[Race_Class]) && ($car_class != '')) {
      echo '<table border="2" cellpadding="7"><tr><td align="center" colspan="2">
<font size="5">'.$car_class.'</font></td></tr>';
      arsort($driver_points);
        foreach ($driver_points as $k => $v) {
          $query2 = "select Last_Name, First_Name from drivers where Driver_ID = '$k'";
          $result2 = mysql_query($query2) 
            or die("Cannot execute select from race");
          $row2 = mysql_fetch_assoc($result2);
          echo '<tr><td><a href="driver_record.php?driver_id='.$k.'&race_year='.$race_year.
'"><u>'.$row2[First_Name].' '.$row2[Last_Name].'</u></a></td><td>'.$v.'</td></tr>';

        }
    echo '</table><br><br>';
    $driver_points = array();
    }
  $results_array = unserialize($row[Results_Array]);
  foreach ($results_array as $keys => $values) {
      
    $query3 = "select Races_Points from drivers where Driver_ID = '$keys'";
    $result3 = mysql_query($query3) 
       or die("Cannot execute select from driver");
    $row3 = mysql_fetch_assoc($result3);
    $race_points = unserialize($row3[Races_Points]);

    $driver_points[$keys] = $driver_points[$keys] + $race_points[$race_id];
  }  
$car_class = $row[Race_Class];
}

echo '<table border="2" cellpadding="7"><tr><td align="center" colspan="2">
<font size="5">'.$car_class.'</font></td></tr>';
arsort($driver_points);
   foreach ($driver_points as $k => $v) {
      $query2 = "select Last_Name, First_Name from drivers where Driver_ID = '$k'";
      $result2 = mysql_query($query2) 
         or die("Cannot execute select from race");
      $row2 = mysql_fetch_assoc($result2);
      echo '<tr><td><a href="driver_record.php?driver_id='.$k.'&race_year='.$race_year.'">
<u>'.$row2[First_Name].' '.$row2[Last_Name].'</u></a></td><td>'.$v.'</td></tr>';
   }

echo '</table><br><br>';
echo $tail;
?>