title: How to submit a form which contains mysql generated dropdown lists
body: <p>Ive got a property website im working on for a school project <a href="http://www.holidayaviemore.com" rel="nofollow">http://www.holidayaviemore.com</a></p>
  
  <p>I have three dropdown lists which have all been generated from a mysql database.</p>
  
  <p>I have added a submit button so that when the options have been selected the database info will display..this is where I am really stuck!</p>
  
  <p>Im not sure what code of functions are needed to diplay the content on the page or on another page..any ideas?  This is the code for the dropdownn boxes and form I have so far..</p>
  
  <p>EDIT
  Basically I want the options selected to be displayed on a webpage <a href="http://www.holidayaviemore.com" rel="nofollow">http://www.holidayaviemore.com</a> shows the dropdown lists</p>
  
  <pre><code>&lt;p&gt;Select Options From Below to find property&lt;/p&gt;
  &lt;form action="#" name="form" id="form" method="post"&gt;
  &lt;?php
  
  
  $sql = "SELECT DISTINCT availability FROM properties";
  $result = mysql_query($sql);
  
  echo "&lt;select name='availability'&gt;&lt;option value=''&gt;- Availability?--&lt;/option&gt;";
  
  while ($row = mysql_fetch_array($result)) {
  echo "&lt;option value='". $row['availability']. "'&gt;" . $row['availability'] ."&lt;/option&gt;";
  } 
  echo "&lt;/select&gt;";
  
  
  ?&gt;
  
  &lt;?php
  
  
  $sql = "SELECT bedrooms FROM properties LIMIT 10";
  $result = mysql_query($sql);
  
  echo "&lt;select name='bedrooms'&gt;&lt;option value=''&gt;--Please Choose Bedrooms  Bedrooms--&lt;/option&gt;";
  $count = 1;
  while ($row = mysql_fetch_array($result)) {
  echo "&lt;option value='" . $row['bedrooms'] . "'&gt; " . $count . "&lt;/option&gt;";
  $count++;
  }
  echo "&lt;/select&gt;";
  
  ?&gt;
  
  
  &lt;?php
  
  
  $sql = "SELECT sleeps_min FROM properties LIMIT 12";
  $result = mysql_query($sql);
  
  echo "&lt;select name='sleeps_min'&gt;&lt;option value=''&gt;--Please Choose Guests--&lt;/option&gt;";
  $count = 1;
  while ($row = mysql_fetch_array($result)) {
  echo "&lt;option value='" . $row['sleeps_min'] . "'&gt; " . $count . "&lt;/option&gt;";
  $count++;
  }
  echo "&lt;/select&gt;";
  
  ?&gt;
  &lt;input type="submit" name="" value="GO" /&gt;
  &lt;/form&gt;
  </code></pre>