<?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_days = $_GET['Race_Date'];

$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'];
$html_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.
*/

if ($race_days == 'today'){
  $today = "SELECT CURDATE()";
  $result3 = mysql_query($today) 
    or die("Cannot execute current date");
  $row3 = mysql_fetch_array($result3);
  $race_date = $row3[0];
}

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


$query = "select Event_Num from events where ((Event_Date = '$race_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'";

$result = mysql_query($query) 
  or die("Cannot execute query");
if($row = mysql_fetch_assoc($result)){
  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>';
}

?>
</table></td><td align="left">

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

<?php

$year = "SELECT year('$race_days')";
$result = mysql_query($year) 
  or die("Cannot execute race year");
$race_year = mysql_fetch_array($result);

$month = "SELECT monthname('$race_days')";
$result = mysql_query($month) 
  or die("Cannot execute race month");
$race_month = mysql_fetch_array($result);

$day = "SELECT DAYOFMONTH('$race_days')";
$result = mysql_query($day) 
  or die("Cannot execute race day");
$race_day = mysql_fetch_array($result);


if ($race_days == 'today'){
echo '<h2>Unofficial Race Results<br>for Today</h2>';

$query = "select * from race where Race_Date = '$race_date' OR 
Race_Date = '$yester_date' order by Race_Class, Status";
} else {
echo '<h2>Unofficial Race Results<br>for '.$race_month[0].' '.$race_day[0].', '.
$race_year[0].'</h2><br><br>';
$query = "select * from race where Race_Date = '$race_days' order by Race_Class, Status";

}

$result = mysql_query($query) 
  or die("Cannot execute query");

while($row = mysql_fetch_assoc($result)){
echo '<h2>'.$row[Race_Class].' - '.$row[Status].' - '.$row[Type].' Race</h2>';
echo $row[Results];

echo '<br><br>';
}

?>

</td></tr></table>

<?php
echo $html_tail;

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