Narrow Results By Resort

All Resorts EOF; if ($airport_code != null || $airport_code != '') { $result = query("select id,hotel_info_id from promotions where airport_codes_id like '%$airport_code%' OR airport_codes_id like '%All%' order by 2"); } else { $result = query("select id,hotel_info_id from promotions where airport_codes_id like '%All%' order by 2"); $airport_code = 'LO'; } $hotel_options = ''; $hotel_info_id = ''; for ($x=0; $x < pg_num_rows($result); $x++) { if (pg_fetch_result($result,$x,1) != 'All') { $id = pg_fetch_result($result,$x,0); $hotel_info_id .= pg_fetch_result($result,$x,1); $y = $x+1; if (substr($hotel_info_id,-1,-1) != '|' && $y < pg_num_rows($result)) { $hotel_info_id = $hotel_info_id."|"; } } } if ($hotel_info_id != 'All' && $hotel_info_id != '') { $hotel_ids = explode("|",$hotel_info_id); sort($hotel_ids); foreach ($hotel_ids as $hotel_id) { if ($hotel_id != null && $hotel_id != '' && $hotel_id != 'All') { $link_query = query("select hotel_name from hotel_infos where id='$hotel_id'"); $hotel_name = pg_fetch_result($link_query,0,0); $hotel_options .= "$hotel_name"; } } } } else { $hotel_options = " Click Here To Show All Resorts"; $extra_hotel_query = "and hotel_info_id like '%".$_GET['hotel']."%'"; } /* print $hotel_options; */ ?>

$promo_details