Mon '; // build facilities search for($i = 0; $i < count($array); $i++){ if ($array[$i]!=0) { $fac .= ' AND facilities_id='.$array[$i].''; } else $fac .= ''; } echo ''; for ($i = 1; $i <= 9; $i++) { // change mon here echo ''; // dynamically build sql query $sql = " SELECT DISTINCT COUNT(*) FROM ts_room rm LEFT JOIN ts_roomfacilities rf ON rm.id = rf.room_id LEFT join ts_facilities f ON f.id = rf.facilities_id LEFT JOIN ts_building b ON rm.building_id=b.id WHERE capacity>=:group_size"; $sql .= $fac; if($park!="Any") { $sql .= " AND b.park_id=:park"; $searchArray[':park'] = $park; } if($lecturestyle_id!="Any") { $sql .= " AND lecturestyle_id=:lecturestyle_id"; $searchArray[':lecturestyle_id'] = $lecturestyle_id; } if($roomstructure_id!="Any") { $sql .= " AND roomstructure_id=:roomstructure_id"; $searchArray[':roomstructure_id'] = $roomstructure_id; } $sql .= " AND rm.id NOT IN (SELECT COUNT(*) FROM ts_request rq LEFT JOIN ts_allocation a ON a.request_id = rq.id WHERE day_id=1 AND period_id=:period OR a.status IS NOT NULL AND a.status IN ('Pending','Declined','Failed'))"; $stm = $pdo->prepare( $sql ); $stm->execute( array( $searchArray, ':period' => $i)); $rows = $stm->fetchColumn(); echo $rows.'
free'; echo ''; } ?>