How to list the vehicle based on selected faculty
<p>i have a list box to show the list of vehicle when user select the faculty. i want to list only the vehicle based on the selected faculty by user. </p>

<pre><code>&lt;td&gt;No&lt;/td&gt;
&lt;td&gt;Registration No&lt;/td&gt;

&lt;?php
     $count = 0;
     $db = mysql_connect('localhost','root') 
     or die ("unable to connect");

 mysql_select_db('fyp',$db) or die ("able to select");
 $sql="SELECT * FROM vehicle_record";
  $result = mysql_query($sql) or die ("Query failed!");
 while($row = mysql_fetch_array($result)){
       $count = $count + 1;
?&gt;

&lt;select name="faculty" &gt;
               &lt;option value="" selected&gt;-- Please Select --&lt;/option&gt;
               &lt;option&gt;City Campus&lt;/option&gt;
               &lt;option&gt;MFI&lt;/option&gt;
               &lt;option&gt;BMI&lt;/option&gt;
               &lt;option&gt;MSI&lt;/option&gt;
               &lt;option&gt;MIAT&lt;/option&gt;
               &lt;option&gt;MICET&lt;/option&gt;
               &lt;option&gt;MIMET&lt;/option&gt;
               &lt;option&gt;RCMP&lt;/option&gt;
             &lt;/select&gt; 
</code></pre>
