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

$driver_id = $_GET['driver_id'];
$race_year = $_GET['race_year'];
$home_club = 'I-5';

$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'];

$today20 = "SELECT CURDATE()";
$result20 = mysql_query($today20) 
  or die("Cannot execute current date");
$row20 = mysql_fetch_array($result20);
$todays_date = $row20[0];

$yesterday = "SELECT DATE_SUB(CURRENT_DATE, INTERVAL 1 DAY)";
$result21 = mysql_query($yesterday) 
  or die("Cannot execute yester date");
$row21 = mysql_fetch_array($result21);
$yester_date = $row21[0];

$query23 = "select Event_Num from events where ((Event_Date = '$todays_date') OR 
(Event_Date = '$yester_date')) AND ((Event_Scope = 'Outlaw') or (Event_Scope = 'Fun') or 
(Event_Scope = 'Club Points')) AND Location = 'Home Track' and Home_Club = '$home_club'";

$result23 = mysql_query($query23) 
  or die("Cannot execute query");
if($row23 = mysql_fetch_assoc($result23)){
echo '<tr><td width="120" height="23"  bgcolor="#FE0002" align="center" valign="center">';
echo '<a href="http://www.i-5qmc.com/race_day.php"><font size="2" face="Helvetica">Race Day';
echo '</font></a></td></tr>';
}

?>

<!--
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">

<table cellspacing="40"><tr><td>

<?php

$query = "select * from drivers where Driver_ID = '$driver_id'";

$result = mysql_query($query) 
  or die("Cannot execute select from drivers");
$row = mysql_fetch_assoc($result);
$driver_points_array = unserialize($row[Races_Points]);
$driver_class_array = unserialize($row[Car_Class]);
$drivers_home = $row[Home_Club];
$drivers_name = $row[First_Name].' '.$row[Last_Name];	

echo '<h2>'.$race_year.' Race Record for '.$drivers_name.' at Elma, WA</h2>';
echo '<table border="2" cellpadding="5" cellspacing="5"align="center">
<tr><td align="center" bgcolor="#0B2F85">Date</td>';
echo '<td align="center" bgcolor="#0B2F85">Description</td><td bgcolor="#0B2F85">Finish
</td><td bgcolor="#0B2F85">Race<br>Points</td>'; 
echo '<td bgcolor="#0B2F85">Total<br>Points</td></tr>';


asort($driver_class_array);
$last_class = '';

foreach ($driver_class_array as $key => $value) {
  if ($last_class != $value) {
    $total_points = 0;

    if ($last_class != ''){
    echo '<tr><td colspan="5" align="center"><font size="5">'.$last_class.'</font></td></tr>';
    ksort($one_class_array);

      foreach ($one_class_array as $k => $v) {

      $query = "select * from race where Race_ID = '$k'";
      $result = mysql_query($query) 
        or die("Cannot execute select from race");
      $row = mysql_fetch_assoc($result);
      $race_date = $row[Race_Date];
  $parsed_date = date_parse("$race_date");
  if ($race_year == $parsed_date[year]) {
      $race_finish = unserialize($row[Results_Array]);
      $finish_array[$k] = $race_finish[$driver_id];

      $query2 = "SELECT monthname('$race_date')";
      $result2 = mysql_query($query2) 
        or die("Cannot execute race month");
      $race_month = mysql_fetch_array($result2);

      $query2 = "SELECT DAYOFMONTH('$race_date')";
      $result2 = mysql_query($query2) 
        or die("Cannot execute race day");
      $race_day = mysql_fetch_array($result2);

      echo '<tr><td>'.$race_day[0].' '.$race_month[0].'</td>
<td>'.$row[Status].' - '.$row[Type];
      echo '</td><td align="center">'.$finish_array[$k].'</td><td align="center">'.
$driver_points_array[$k].'</td><td align="center">';
      $total_points = $total_points + $driver_points_array[$k];
  
      echo $total_points.'</td></tr>';
      }
     
      }

    $one_class_array = array();
    }
   $last_class = $value;
  }
$one_class_array[$key] = $driver_class_array[$key];
}

$total_points = 0;
echo '<tr><td colspan="5" align="center"><font size="5">'.$last_class.
'</font></td></tr>';
ksort($one_class_array);
  foreach ($one_class_array as $k => $v) {

  $query = "select * from race where Race_ID = '$k'";
  $result = mysql_query($query) 
     or die("Cannot execute select from race");
  $row = mysql_fetch_assoc($result);
  $race_date = $row[Race_Date];
  $parsed_date = date_parse("$race_date");
  if ($race_year == $parsed_date[year]) {
  $race_finish = unserialize($row[Results_Array]);
  $finish_array[$k] = $race_finish[$driver_id];

  $query2 = "SELECT monthname('$race_date')";
  $result2 = mysql_query($query2) 
     or die("Cannot execute race month");
  $race_month = mysql_fetch_array($result2);

  $query2 = "SELECT DAYOFMONTH('$race_date')";
  $result2 = mysql_query($query2) 
     or die("Cannot execute race day");
  $race_day = mysql_fetch_array($result2);

  echo '<tr><td>'.$race_day[0].' '.$race_month[0].'</td><td>'.$row[Status].' - '.$row[Type];
  echo '</td><td align="center">'.$finish_array[$k].'</td><td align="center">'.
$driver_points_array[$k].'</td><td align="center">';
  $total_points = $total_points + $driver_points_array[$k];
  
  echo $total_points.'</td></tr>';
  }
  }
 
echo '</table></td></tr></table>';

$query = "select Tail from html where Home_Club = '$home_club'";
$result = mysql_query($query) 
  or die("Cannot execute query");
$row = mysql_fetch_assoc($result);
echo $row['Tail'];

$result->free();
$db->close();
?>