<?php
	require_once('config.php');
	
	$date = date("Y-m-d");
	$datetime = date("Y-m-d H:i:s");
	
	//Connect to mysql server
	$link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
	if(!$link) {
		die('Failed to connect to server: ' . mysql_error());
	}
	
	//Select database
	$db = mysql_select_db(DB_DATABASE);
	if(!$db) {
		die("Unable to select database");
	}		
	
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>California International Marathon -- Flash Results, Inc.</title>

<style type="text/css">
A.link:visited { text-decoration:none; color: #000000; }
A.link { text-decoration:none; color:#000000; }
A.link:hover { text-decoration:none; color:#000000; }

A.info:visited { text-decoration:underline; color: #000000; }
A.info { text-decoration:underline; color:#000000; }
A.info:hover { text-decoration:none; color:#000000; }

.outside td { border-right:solid 1px #d5d5d5;border-left:solid 1px #d5d5d5; }

.bottom td { border-top:solid 1px #d5d5d5; }

.counter { border-right:solid 1px #000066; border-left:solid 1px #000066; border-top:solid 1px #000066; border-bottom:solid 1px #000066; }

.bottominside td { border-top:solid 0px #d5d5d5; }

.noborder td { border-left:solid 0px #d5d5d5;border-right:solid 0px #d5d5d5; }
</style>

</head>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">

<table width='100%' bgcolor='#ffcc33' border="0" cellspacing="0" cellpadding="0" align="center">
	<tr>
    	<td width='100%'>
        
        	<table width='1000' align='center'>
            	<tr>
            		<td width='350' align='left'>
                    <font face='calibri' color='#000066' size='+1'><b>California International Marathon</b></font>
            		</td>

            		<td width='100' align='center' onmouseover="this.style.backgroundColor='#ffe188'" onmouseout="this.style.backgroundColor='#ffcc33'">
                    <a href='http://www.flashresults.com/2011_Meets/CIM/' class='link'>
                    <font face='calibri' color='#000066'>Home</font>
                    </a>
            		</td>


            		<td width='150' align='center' onmouseover="this.style.backgroundColor='#ffe188'" onmouseout="this.style.backgroundColor='#ffcc33'">
                    <a href='http://www.flashresults.com/2011_Meets/CIM/searchrelay/' class='link'>
                    <font face='calibri' color='#000066'>Relay Results</font>
                    </a>
            		</td>

            		<td width='150' align='center' onmouseover="this.style.backgroundColor='#ffe188'" onmouseout="this.style.backgroundColor='#ffcc33'">
                    <a href='http://www.flashresults.com/2011_Meets/CIM/searchind/' class='link'>
                    <font face='calibri' color='#000066'>Marathon Results</font>
                    </a>
            		</td>

            		<td width='150' align='center' onmouseover="this.style.backgroundColor='#ffe188'" onmouseout="this.style.backgroundColor='#ffcc33'">
                    <a href='http://www.flashresults.com/2011_Meets/CIM/leaderboards/' class='link'>
                    <font face='calibri' color='#000066'>Leaderboard</font>
                    </a>
            		</td>

            		<td width='150' align='center' onmouseover="this.style.backgroundColor='#ffe188'" onmouseout="this.style.backgroundColor='#ffcc33'">
                    <a href='http://www.flashresults.com/2011_Meets/CIM/athletetracking/' class='link'>
                    <font face='calibri' color='#000066'>Athlete Tracking</font>
                    </a>
            		</td>

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

</table>

<table width='1000' align='center' class='outside'>
	<tr>
		<td width='100%'>


			<table width='99%' class='noborder' border='0' align='center'>
            	<tr>
                	<td width='100%' valign='top'>
                       <br />   
                       


<table width='975' align='center'>
<tr>
<td width='50%' align='center'>
<font face='calibri' size='+3'>California International Marathon</font><br>
<font face='calibri' size='+2'><i>Sacramento, CA</i></font><br>
<font face='calibri' size='+2'><b>Marathon Results</b></font>
</td>

<td width='50%'>


<?php
$result5 = mysql_query("SELECT * FROM runnermaster");
$num_rows5 = mysql_num_rows($result5);

$result6 = mysql_query("SELECT * FROM runnermaster WHERE Sex = 'M'");
$num_rows6 = mysql_num_rows($result6);

$result7 = mysql_query("SELECT * FROM runnermaster WHERE Sex = 'F'");
$num_rows7 = mysql_num_rows($result7);

echo "
<table width='100%' align='center' class='counter' bgcolor='#fee8a6'>
<tr>
<td width='100%'>
&nbsp;&nbsp;<font face='calibri'><b>Total Finishers:</b> $num_rows5<br>
&nbsp;&nbsp;<font face='calibri'><b>Male Finishers:</b> $num_rows6<br>
&nbsp;&nbsp;<font face='calibri'><b>Women Finishers:</b> $num_rows7<br>
</td>
</tr>
</table>";


?>

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




<table width='975' align='center'>
<tr>
<td width='100%'>

<table width='975'>

		<tr>
		<td width='975' valign='top' align='center'>
        <br>
<?php        
     
echo "	    
<font face='calibri' size='+2'>
<a href='SearchResultsMarathon-view.php?fname=$fname&lname=$lname&city=$city&state=$state&division=$division&sex=$sex&l=$l&h=$h' class='info'>Back to List</a>
</font>
<br><br>
<br><br>";

$result = mysql_query("SELECT * FROM runnermaster WHERE BibNum='$Bib' LIMIT 1");

while($row = mysql_fetch_array($result))
  {


echo "

<table width='400' border='0' cellspacing='2' cellpadding='2' align='center'>

<tr>
	<td width='100%' align='center' colspan='2'>
	<font face='calibri' color='#000000' size='+3'>" . $row['FirstName'] . " " . $row['LastName'] . "</font>
	<br>";
	
if($row['Country'] == 'Usa')
{echo "<font face='calibri' color='#000000' size='+2'><i>" . $row['City'] . ", " . $row['State'] . "</i></font>";}
else{echo "<font face='calibri' color='#000000' size='+2'><i>" . $row['Country'] . "</i></font>";}	
	
	
echo "	
	</td>
</tr>	

<tr>
	<td colspan='2'><br></td>
</tr>

<tr>
	<td width='30' bgcolor='#eaeaea'>&nbsp;<font face='calibri' color='#000000'><b>Age</b></font></td>
	<td width='100'><font face='calibri' color='#000000'>&nbsp;&nbsp;&nbsp;" . $row['Age'] . "</font></td>
</tr>	

<tr>
	<td colspan='2'><br></td>
</tr>

<tr>
	<td width='30' bgcolor='#eaeaea'>&nbsp;<font face='calibri' color='#000000'><b>Sex</b></font></td>
	<td width='100'><font face='calibri' color='#000000'>&nbsp;&nbsp;&nbsp;" . $row['Sex'] . "</font></td>
</tr>
<tr>
	<td width='30' bgcolor='#eaeaea'>&nbsp;<font face='calibri' color='#000000'><b>Sex Place</b></font></td>
	<td width='100'><font face='calibri' color='#000000'>&nbsp;&nbsp;&nbsp;" . $row['SexPlace'] . " of " . $row['SexTotal'] . " </font></td>
</tr>			

<tr>
	<td colspan='2'><br></td>
</tr>

<tr>
	<td width='30' bgcolor='#eaeaea'>&nbsp;<font face='calibri' color='#000000'><b>Division</b></font></td>
	<td width='100'><font face='calibri' color='#000000'>&nbsp;&nbsp;&nbsp;" . $row['Division'] . "</font></td>
</tr>	
<tr>
	<td width='30' bgcolor='#eaeaea'>&nbsp;<font face='calibri' color='#000000'><b>Div Place</b></font></td>
	<td width='100'><font face='calibri' color='#000000'>&nbsp;&nbsp;&nbsp;" . $row['DivPlace'] . " of " . $row['DivTotal'] . " </font></td>
</tr>	


<tr>
	<td colspan='2'><br></td>
</tr>


<tr>
	<td width='30' bgcolor='#eaeaea'>&nbsp;<font face='calibri' color='#000000'><b>Place</b></font></td>
	<td width='100'><font face='calibri' color='#000000'>&nbsp;&nbsp;&nbsp;" . $row['Place'] . "</font></td>
</tr>	

<tr>
	<td width='30' bgcolor='#eaeaea'>&nbsp;<font face='calibri' color='#000000'><b>Time</b></font></td>
	<td width='100'><font face='calibri' color='#000000'>&nbsp;&nbsp;&nbsp;" . $row['GunTime'] . "</font></td>
</tr>	
<tr>
	<td width='30' bgcolor='#eaeaea'>&nbsp;<font face='calibri' color='#000000'><b>Pace</b></font></td>
	<td width='100'><font face='calibri' color='#000000'>&nbsp;&nbsp;&nbsp;" . $row['GunPace'] . "</font></td>
</tr>

<tr>
	<td colspan='2'><br></td>
</tr>

<tr>
	<td width='30' bgcolor='#eaeaea'>&nbsp;<font face='calibri' color='#000000'><b>Net Place</b></font></td>
	<td width='100'><font face='calibri' color='#000000'>&nbsp;&nbsp;&nbsp;" . $row['ChipPlace'] . "</font></td>
</tr>	

<tr>
	<td width='30' bgcolor='#eaeaea'>&nbsp;<font face='calibri' color='#000000'><b>Net Time</b></font></td>
	<td width='100'><font face='calibri' color='#000000'>&nbsp;&nbsp;&nbsp;" . $row['ChipTime'] . "</font></td>
</tr>	
<tr>
	<td width='30' bgcolor='#eaeaea'>&nbsp;<font face='calibri' color='#000000'><b>Net Pace</b></font></td>
	<td width='100'><font face='calibri' color='#000000'>&nbsp;&nbsp;&nbsp;" . $row['ChipPace'] . "</font></td>
</tr>

<tr>
	<td colspan='2'><br></td>
</tr>

<tr>
	<td colspan='2' align='center'><font face='calibri' color='#000000' size='+1'><b>5.9 Mile Split</b></font></td>
</tr>
<tr>
	<td width='30' bgcolor='#eaeaea'>&nbsp;<font face='calibri' color='#000000'><b>Place</b></font></td>
	<td width='100'><font face='calibri' color='#000000'>&nbsp;&nbsp;&nbsp;" . $row['Split1Place'] . "</font></td>
</tr>	

<tr>
	<td width='30' bgcolor='#eaeaea'>&nbsp;<font face='calibri' color='#000000'><b>Gun Split</b></font></td>
	<td width='100'><font face='calibri' color='#000000'>&nbsp;&nbsp;&nbsp;" . $row['Split1GunSplit'] . "</font></td>
</tr>	
<tr>
	<td width='30' bgcolor='#eaeaea'>&nbsp;<font face='calibri' color='#000000'><b>Net Split</b></font></td>
	<td width='100'><font face='calibri' color='#000000'>&nbsp;&nbsp;&nbsp;" . $row['Split1NetSplit'] . "</font></td>
</tr>

<tr>
	<td colspan='2'><br></td>
</tr>

<tr>
	<td colspan='2' align='center'><font face='calibri' color='#000000' size='+1'><b>Halfway Split</b></font></td>
</tr>
<tr>
	<td width='30' bgcolor='#eaeaea'>&nbsp;<font face='calibri' color='#000000'><b>Place</b></font></td>
	<td width='100'><font face='calibri' color='#000000'>&nbsp;&nbsp;&nbsp;" . $row['Split2Place'] . "</font></td>
</tr>	

<tr>
	<td width='30' bgcolor='#eaeaea'>&nbsp;<font face='calibri' color='#000000'><b>Gun Split</b></font></td>
	<td width='100'><font face='calibri' color='#000000'>&nbsp;&nbsp;&nbsp;" . $row['Split2GunSplit'] . "</font></td>
</tr>	
<tr>
	<td width='30' bgcolor='#eaeaea'>&nbsp;<font face='calibri' color='#000000'><b>Net Split</b></font></td>
	<td width='100'><font face='calibri' color='#000000'>&nbsp;&nbsp;&nbsp;" . $row['Split2NetSplit'] . "</font></td>
</tr>
<tr>
	<td colspan='2'><br></td>
</tr>

<tr>
	<td colspan='2' align='center'><font face='calibri' color='#000000' size='+1'><b>20 Mile Split</b></font></td>
</tr>
<tr>
	<td width='30' bgcolor='#eaeaea'>&nbsp;<font face='calibri' color='#000000'><b>Place</b></font></td>
	<td width='100'><font face='calibri' color='#000000'>&nbsp;&nbsp;&nbsp;" . $row['Split3Place'] . "</font></td>
</tr>	

<tr>
	<td width='30' bgcolor='#eaeaea'>&nbsp;<font face='calibri' color='#000000'><b>Gun Split</b></font></td>
	<td width='50'><font face='calibri' color='#000000'>&nbsp;&nbsp;&nbsp;" . $row['Split3GunSplit'] . "</font></td>
</tr>	
<tr>
	<td width='30' bgcolor='#eaeaea'>&nbsp;<font face='calibri' color='#000000'><b>Net Split</b></font></td>
	<td width='100'><font face='calibri' color='#000000'>&nbsp;&nbsp;&nbsp;" . $row['Split3NetSplit'] . "</font></td>
</tr>
";



  }
  
?>
</table>

</td>





</table>









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






















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





<br /><br /><br />





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





<table width='100%' border="0" cellspacing="0" cellpadding="0" align="center" class='bottom'>
	<tr>
    	<td width='100%'>
        
        	<table width='1000' align='center' class='bottominside'>
            	<tr>
            		<td width='50%' align='left'>
                    <font face='calibri' color='#b1b1b1'>Flash Results, Inc.</font>
            		</td>
             		<td width='50%' align='right'>
                    <img src='ipico.jpg' />&nbsp;&nbsp;<img src='lynx.jpg' />
            		</td>
            	</tr>
            	<tr>
            		<td width='1000' align='center' colspan='2'>
                    <font face='calibri' color='#b1b1b1' size='-1'>Results are the property of Flash Results, Inc and can not be reproduced in any way without the express written consent of Flash Results, Inc. <b>Copyright © 2010 Flash Results, Inc.</b></font>
            		</td>
            	</tr>

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

</table>

</body>
</html>
