$db database successfully!";
}
try {
$date = new DateTime("now", new DateTimeZone('Australia/Melbourne'));
} catch (Exception $e) {
echo $e->getMessage();
exit(1);
}
$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, horses.horse_no;", $conn->quote($date->format('Y-m-d')));
$stmt = $conn->query($query);
/*
$r = $stmt->fetch(PDO::FETCH_ASSOC);
print "
" ;
print_r($r);
print "
";
*/
$query = sprintf("SELECT * FROM race_program
WHERE race_date >= %s AND torn = TRUE
ORDER BY race_date, venue, race;", $conn->quote($date->format('Y-m-d')));
$stmt2 = $conn->query( $query );
?>
TAG;
$head_displayed = False;
while($row = $stmt->fetch(PDO::FETCH_ASSOC)) : ?>
';
echo '