PHP - Cure For Long Drop Down Boxes

Hi

I have 3 drop down boxes and I want my boxes to go to another page when I select them and click go. For example if I click western cape I want it to give me all the resorts in western cape and if I click western cape and beaches I want it to give me all the resorts that are in the western cape that are next to beaches. I have been able to populate the drop down boxes with information and it can go to another page but it doesn't give me the information I want.

This is my drop down boxes code

Code: [Select]
<script type="text/javascript">

function showGo(){

 

      var region_id = $("#region_id").val();

      var lifestyle_id = $("#lifestyle_id").val();

      var resort_facility_id = $("#resort_facility_id").val();

 

      if((region_id != 'false') || (lifestyle_id != 'false') || (resort_facility_id != 'false')){

 

            $("#destinationSearchButton").css('display', 'block');

           

      }else{

 

            $("#destinationSearchButton").css('display', 'none');

      }

 

 

 

</script>


<form action="/pages/search/" method="post">

<select class="formSelect" name="region_id" id="region_id" size="1" tabindex="1" onchange="showGo()">
<option label="Region">
<?php

$regions_model = new regions_model('regions');
$regions = $regions_model -> get_all();

 foreach($regions as $region){
$name = $region['name'];
$id =$region['id'];

$select = "SELECT $id, $name FROM regions";
  echo "<option value='$id'>$name</option>";
 } ?>
</option>

</select>

<select class="formSelect" name="lifestyle_id" id="lifestyle_id" size="1" tabindex="2" onchange="showGo()">
<option label="lifestyle">
<?php

$lifestyles_model = new lifestyles_model('lifestyles');
$lifestyles = $lifestyles_model -> get_all();

 foreach($lifestyles as $lifestyle){
$name = $lifestyle['name'];
$id = $lifestyle['id'];

$select = "SELECT $name FROM lifestyles";
  echo "<option name='$id'>$name</option>";
 } ?>
</option>
</select>


<select class="formSelect" name="resort_facility_id" id="resort_facility_id" size="1" tabindex="3" onchange="showGo()">
<option label="Facilities & Amenities">
<?php

$resort_facilities_model = new resort_facilities_model('resort_facilities');
$resort_facilities= $resort_facilities_model -> get_all();

 foreach($resort_facilities as $resort_facility){
$name = $resort_facility['name'];
$id = $resort_facility['id'];

$select = "SELECT $name FROM resort_failities";
  echo "<option name='$id'>$name</option>";
 } ?>
</option>
</select>

<input class="formInputButton" type="submit" name="submitButtonName" id="destinationSearchButton" value="Go" tabindex="4"/ style="display: none;" />
</form>
</div>

Thank you

Hi all

Im looking to do a "SIMPLE"  search on a databse usign php.

I want to have a drop down box like so :

<select name="Lowest">
  <option>0</option>
  <option>100</option>
  <option>200</option>
</select>

this is for the prices i want 2 of these so that the first will be the lowest price and the second will be the higher price

Then i will make a query to SELECT * WHERE ( i dont know how to call the results from the select box here to display the whole tabled results )

any help please

thnax

Hey, I'm new to php and I made a webpage that searches a text file and displays a list of courses I've taken depending on what you type into a textbox. I want to change it instead into two drop-down boxes (one for department one for semester) and a all button so that it's neater and to prevent errors. Here is what I have currently:

http://codepad.org/nX6g9zh2

Please help! Thank you!