foreach ($openingHours as $oHour) { $oHours[] = "(`date`='$tdate' AND hour=$oHour)"; } $whereString = implode(' OR ', $oHours); $query = 'SELECT ID,`type`,room_ID,UNIX_TIMESTAMP(date) AS tdate,hour ' . 'FROM bookings ' . "WHERE $whereString AND hour >= $thour " . "ORDER BY ABS(UNIX_TIMESTAMP(date) - $target) ASC";