<select name="select" id="select">
<option value=" " selected="selected">please choose</option>
<?php
$sql = "select * from live
order by type ASC";
$result = mysql_query($sql);
$num = mysql_num_rows($result);
for ($i=1;$i<=$num;$i++){
$row = mysql_fetch_array($result);
?>
<option value="<?php echo $row["type"] ?>"><?php echo $row["type"] ?></option>
<?php }?>
</select>
<select name="select2" id="select2">
<option value=" " selected="selected">please choose</option>
<?php
$sql = "select * from live where home!=''
order by home ASC";
$result = mysql_query($sql);
$num = mysql_num_rows($result);