Help with drop menu

[beastylad]

Hi i currenlty have adrop box filled with companies so the user can select which company they woudl like services from but the default is currently 0 and is to selecvt all firms but im unsure how to do this.

 

Current code:

<td>Taxi Firm</td><td> <select name="taxifirm">
<option value="0" selected>All Taxi Firms</option>
<?php
$sql = mysql_query("SELECT * FROM taxi_Firms"); 
	while($row = mysql_fetch_array($sql)){
		$uid = $row["Firm_ID"];
		$username = $row["Firm_Name"]; 
		echo '<option value="'.$uid.'">'.$username.'</option>' ;

	}
?>

 

amny help is welcomed

 

thanx

[Muddy_Funster]

conditional generation of the where clause?

if($_POST['taxifirm'] == 0){
$where = '';
}
else{
$where = "WHERE Firm_ID = {$_POST['taxifirm']}";