Code: Select all
function room_unavailable($room_name, $s_at, $e_at){
$room_name = sanitize($room_name);
// $s_at = sanitize();
// $e_at = sanitize();
$query = mysql_query("SELECT COUNT('room_name') FROM `ordered_rooms` WHERE (`s_at` BETWEEN 7 AND '$e_at') AND (`e_at` BETWEEN '$s_at' AND 18)AND `room_name`= '$room_name'");
echo intval((mysql_result($query, 0)));
}
Code: Select all
return (mysql_result($q, 0)== 1) ? true: false;Code: Select all
echo (mysql_result($query, 0));