"David Robley" <[EMAIL PROTECTED]> wrote in message
> In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
> > Hi,
> > I have a table called Bookings which has two important columns;
> > Booking_Start_Time and Booking_End_Time. These columns are both of type
> > DATETIME. Given any day how can I calculate how many hours are available
> > between the hours of 09.00 and 17.30 so a user can see at a glance how
> > hours they have unbooked on a particular day, can this be done with a
> > or do I have to work it out with PHP?
> > Thanks for your help
> Seems easy enough - just sum the time booked per day and subtract it from
> the constant which is the total of available hours, and group by day.
> You'll need to calculate the booked time based on existing start/end
> values but you should be able to do that in SQL.
> Quod subigo farinam
> A: Because it messes up the order in which people normally read text.
> Q: Why is top-posting such a bad thing?
> A: Top-posting.
> Q: What is the most annoying thing on usenet?
Thanks for your reply,
I am having some odd results with this, just wondering if you could check
this query for me:
"SELECT COUNT(B.Booking_ID) AS Booking_ID,
SUM(8.5 - (DATE_FORMAT(Booking_Start_Date, '%h:%i:%s')) +
(DATE_FORMAT(B.Booking_End_Date, '%h:%i:%s'))) AS Available_Hours
FROM WMS_Bookings B
WHERE B.User_ID = '".$user_id."'
AND B.Booking_Status <> '1'
Thanks for your help
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php