<?php
$link = mysql_connect('IG88', 'USER_ID', 'PASSWORD');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
mysql_select_db(racing);
$query = "select * from html where Home_Club = 'I-5'";
$result = mysql_query($query)
or die("Cannot execute query");
$row = mysql_fetch_assoc($result);
echo $row['Head'];
echo $row['Menu_Top'];
$bottom_menu = $row['Menu_Bottom'];
$html_tail = $row['Tail'];
$today = "SELECT CURDATE()";
$result3 = mysql_query($today)
or die("Cannot execute current date");
$row3 = mysql_fetch_array($result3);
$todays_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];
?>
<!--
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.
-->
<?php
echo $bottom_menu;
?>
<!--
<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000"
codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=
6,0,40,0" width="640" height="360" id="mbox_player_3096d4b71713e0c6be"><param name="movie"
value="http://www.motionbox.com/external/hd_player/
type%253Dsd%252Cvideo_uid%253D3096d4b71713e0c6be" /><param name="allowScriptAccess"
value="always" /><param name="allowFullscreen" value="true" /><embed
src="http://www.motionbox.com/external/hd_player/
type%253Dsd%252Cvideo_uid%253D3096d4b71713e0c6be" type="application/x-shockwave-flash"
pluginspage="http://www.adobe.com/go/getflashplayer" width="640" height="360"
allowFullscreen="true" allowScriptAccess="always"
name="mbox_player_3096d4b71713e0c6be"></embed></object>
-->
<object width="560" height="340"><param name="movie"
value="http://www.youtube.com/v/zUS7KfBhxIA&hl=en&fs=1&"></param><param
name="allowFullScreen" value="true"></param><param name="allowscriptaccess"
value="always"></param><embed src="http://www.youtube.com/v/zUS7KfBhxIA&hl=en&fs=1&"
type="application/x-shockwave-flash" allowscriptaccess="always" allowfullscreen="true"
width="560" height="340"></embed></object>
<br><font size="3"><font color="#ffffff" face="Helvetica">Mudslinger Shootout - Sr. Honda
A Main - Aug 30, 2009<br>Video production by Aaron Reed<br>Note: Flash video
doesn't work with 64bit Internet Explorer. Use 32bit browser.</font>
<?php
$first_round = 1;
$query = "select * from events where Home_Club = 'I-5' order by Event_Date";
$result = mysql_query($query)
or die("Cannot execute query");
while($row = mysql_fetch_assoc($result)){
$today = "SELECT CURDATE()";
$result10 = mysql_query($today)
or die("Cannot execute current date");
$row10 = mysql_fetch_array($result10);
$cutoff = "SELECT INTERVAL 60 DAY + '$row10[0]'";
$result11 = mysql_query($cutoff)
or die("Cannot execute event day name");
$row11 = mysql_fetch_array($result11);
if ($row['Thru_Date'] != "0000-00-00"){
$event_day = $row['Thru_Date'];
} else {
$event_day = $row['Event_Date'];
}
if ( ($row['Event_Date'] <= $row11[0]) && ($event_day >= $row10[0])){
if ($first_round == 1){
echo '<p valign="top" align="center"><br><b><i><font size="6" color="#fff47c">
Upcoming Events</font></i></b></a><br>';
}
$first_round = $first_round + 1;
$ev_n = $row['Event_Date'];
$event_dayname = "SELECT dayname('$ev_n')";
$result1 = mysql_query($event_dayname)
or die("Cannot execute event day name");
$row1 = mysql_fetch_array($result1);
$ev_m = $row['Event_Date'];
$event_month = "SELECT monthname('$ev_m')";
$result2 = mysql_query($event_month)
or die("Cannot execute event month");
$row2 = mysql_fetch_array($result2);
$ev_d = $row['Event_Date'];
$event_day = "SELECT DAYOFMONTH('$ev_d')";
$result3 = mysql_query($event_day)
or die("Cannot execute event day");
$row3 = mysql_fetch_array($result3);
if ($row['Thru_Date'] != "0000-00-00"){
$ev_nn = $row['Thru_Date'];
$event_dayname2 = "SELECT dayname('$ev_nn')";
$result4 = mysql_query($event_dayname2)
or die("Cannot execute event day name2");
$row4 = mysql_fetch_array($result4);
$ev_mm = $row['Thru_Date'];
$event_month2 = "SELECT monthname('$ev_mm')";
$result5 = mysql_query($event_month2)
or die("Cannot execute event month2");
$row5 = mysql_fetch_array($result5);
$ev_dd = $row['Thru_Date'];
$event_day2 = "SELECT DAYOFMONTH('$ev_dd')";
$result6 = mysql_query($event_day2)
or die("Cannot execute event day2");
$row6 = mysql_fetch_array($result6);
if ($row['URL'] == NULL) {
echo '<hr width="30%"><font size="4">'.$row1[0].', '.$row2[0].' '.$row3[0].' through ';
echo $row4[0].', '.$row5[0].' '.$row6[0].'<br>';
echo $row['Description'].'</font>';
if ($row['Location']){
echo '<br><font size="2">at '.$row['Location'].'</font>';
}
} else {
echo '<hr width="30%"><font size="4">'.$row1[0].', '.$row2[0].' '.$row3[0].' through ';
echo $row4[0].', '.$row5[0].' '.$row6[0].'<br>';
echo '<a href="'.$row['URL'].'"><u></font><font size="4"';
echo ' color="#fff47c" face="Helvetica">'.$row['Description'];
echo '</u></a></font>';
if ($row['Location']){
echo '<br><font size="2">at '.$row['Location'].'</font>';
}
}
} else {
if ($row['URL'] == NULL) {
echo '<hr width="30%"><font size="4">'.$row1[0].', '.$row2[0].' '.$row3[0].' - ';
echo $row['Description'].'</font>';
if ($row['Location']){
echo '<br><font size="2">at '.$row['Location'].'</font>';
}
} else {
echo '<hr width="30%"><font size="4">'.$row1[0].', '.$row2[0].' '.$row3[0].' - ';
echo '<a href="'.$row['URL'].'"><u></font><font size="4"';
echo ' color="#fff47c" face="Helvetica">'.$row['Description'];
echo '</u></a></font>';
if ($row['Location']){
echo '<br><font size="2">at '.$row['Location'].'</font>';
}
}
}
}
}
?>
<br>
<br><br>
<p align="center"><a href="http://www.quarter-midget.net/FredBrownfield.htm">
<img src="http://www.quarter-midget.net/sticker.gif" border="0" ></a></p>
</td><td align="center" valign="top" width="350" bgcolor="#0A172A">
<IFRAME SRC="http://www.quarter-midget.net/index_new4.htm" WIDTH=350 height=1000 HSPACE=0
VSPACE=0 FRAMEBORDER=0 >
</IFRAME>
<?php
echo $html_tail;
?>
