Mine

Table Structures...

MEETINGS   MeetingID, RoomID, Time, Date,
ROOMS      RoomID, Capacity, Building, 



$sql = 

"SELECT *, to_days(Meetings.Date) = to_days('{$date}') as Meeting_today from Rooms left outer join Meetings on Rooms.VenueID = Meetings.VenueID order by (to_days(Meetings.Date) = to_days('{$date}'));						order by (to_days(Meetings.Date) = to_days('{$date}'))
";