Is it just crap or has my God forsaken me
//-------------------------------------------------------------------------------------------------------------
//
ConnectMeetingRoom();
$connection = mysql_connect("172.29.34.104", "intranet", "intranet");
$sqlAMOff = "SELECT rooms.* FROM rooms WHERE rooms.Available = 'Yes' and rooms.RoomsId LIKE
(SELECT contactdetails.Office FROM contactdetails LEFT JOIN absent ON contactdetails.Contact_Id=absent.User_Id and
(absent.Start_Date >='$TempDate' and absent.End_Date <='$TempDate')
WHERE absent.User_Id IS NULL,$connection)";
$resultAMOff = mysql_query($sqlAMOff);
//
//---------------------------------------------------------------------------------------------------------------