Page:
http://clients.justravis.com/spawar/schedule.tap
Code:
http://clients.justravis.com/spawar/schedule.taps
Queries:
SELECT beg, end, name.name FROM reservation, name WHERE mo='2'AND day='10' AND yr='2003' AND reservation.nameid=name.id
SELECT beg, end, name.name FROM reservation, name WHERE mo='2'AND day='10' AND yr='2003' AND beg='8:00' AND reservation.nameid=name.id
Both Return:
08:00:00 10:00:00 Warhead Locator Phase 1
Here is some other info that may be relevent:
beg & end are in time format in mysql. From mySQL manual:
$time is an array that contains the times of the day. Here is the for loop that creates it:TIME values with colons, by contrast, are always treated as time of the day. That is '11:12' will mean '11:12:00', not '00:11:12'
Code: Select all
<?php
#Populating time array.
for($i=8; $i<=17; $i++)
{
$time[]= $i . ':00';
}
?>