<? 
$query="SELECT sub_cat_id, sub_cat_name FROM category";
 
/* You can add order by clause to the sql statement if the names are to be displayed in alphabetical order */
 
$result = mysql_query ($query);
echo "<select name=category value=''></option>";
// printing the list box select command
 
while($nt=mysql_fetch_array($result)){//Array or records stored in $nt
echo "<option value=$nt[sub_cat_id]>$nt[sub_cat_name]</option>";
/* Option values are added by looping through the array */
}
echo "</select>";// Closing of list box 
?>

$result = mysql_query ($query);
echo "<select name=Location value=''>Location</option>";
// printing the list box select command
 
while($nt=mysql_fetch_array($result)){//Array or records stored in $nt
echo "<option value=$nt[Town]>$nt[Location]</option>";
/* Option values are added by looping through the array */
}
echo "</select>";// Closing of list box
 
mysql_free_result($result) ;