Racing Australia
$db database successfully!";
}
$query = sprintf("SELECT * FROM horses JOIN race_program
ON horses.race_date = race_program.race_date
AND horses.venue = race_program.venue
AND horses.race = race_program.race
WHERE horses.race_date >= %s
ORDER BY horses.race_date, horses.venue, horses.race;", $conn->quote(date("Y-m-d")));
$stmt = $conn->query($query);
/*
$r = $stmt->fetch(PDO::FETCH_ASSOC);
print "
" ;
print_r($r);
print "
";
*/
?>
| venue |
state |
date |
race |
start |
utc |
horse |
TABLEHEAD;
$table_foot = <<
TABLEFOOT;
echo( $table_head );
$new_venue = '';
$new_day = '';
$head_displayed = False;
while($row = $stmt->fetch(PDO::FETCH_ASSOC)) : ?>
';
echo '' . htmlspecialchars($row['race_date']) . '
';
echo ' ';
$new_day = $row['race_date'];
$head_displayed = True;
}
} else {
$new_day = $row['race_date'];
}
if ( $new_venue != '' ) {
if ( $new_venue != $row['venue'] ) {
echo $table_foot;
echo $table_head;
$new_venue = $row['venue'];
}
} else {
$new_venue = $row['venue'];
}
?>
|
|
|
|
|
|
|
getMessage();
}
?>