rendered paste body function available_times($requested_date) { $datetime = date('Y-m-d',$requested_date); //Parent Array $requested_times = array(); $query = "SELECT date_time FROM kvmrequests WHERE status='1' OR status='2' AND date_time LIKE '".$datetime." %'"; $result = mysql_query($query) or die(mysql_error()); while ($row = mysql_fetch_array($result)) { $rowtime = strtotime($row['date_time']); $requested_times[] = $rowtime; } return $requested_times; } function get_times($requested_date) { //test date //$requested_date = '1177884000'; $requested_times = available_times($requested_date); //Paremt Array $standard_timeslots = array(); $timeslots = array(); $t = '0'; while ($t < '23') { if ($t % 2 == '0') { $standard_timeslots[] = mktime(0 + $t, 0, 0, date("m", $requested_date), date("d", $requested_date), date("y", $requested_date)); } $t++; } $timeslots = array_diff($standard_timeslots, $requested_times); return $timeslots; }