Example #1
0
<?PHP
if (!isset($_GET['raceId']) || !is_numeric($_GET['raceId'])) {
    echo "Set race ID ";
    exit;
}
$raceId = mysql_real_escape_string($_GET['raceId']);
include_once('../include/db.php');
$db = new Database();
$query = "SELECT name FROM tblRace WHERE id=" . $raceId;
$db->query($query);
$db->singleRecord();
$raceName = $db->Record['name'];
?>
<!DOCTYPE html>
<html dir="ltr" xmlns="http://www.w3.org/1999/xhtml">

    <head>
        <title><?PHP echo "Score Board of: $raceName" ?></title>
        <meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
        <link href="../style/scoreboard.css" rel="stylesheet" type="text/css" />

        <script type="text/javascript" src="../scripts/jquery-1.7.2.min.js"></script>
        <script type="text/javascript" src="http://maps.googleapis.com/maps/api/js?sensor=false">
        </script>
        <script type="text/javascript">
<?/*PHP
$query = "SELECT" .
        " tblCheckpoint.latitude," .
        " tblCheckpoint.longitude," .
        " tblCheckpoint.checkpointName," .
        " COUNT(tblLog.id)" .