Extract data from table and make listing in the selection drop down menu

Make a drop down box as below..


Agency Name : <select name="center_name">
<option selected value="">Select Agency Name</option>

<?php
$conn = mysql_connect('localhost','root','password');
if(!$conn) die("Failed to connect to database!");
$status = mysql_select_db('database_name', $conn);
if(!$status) die("Failed to select database!");

$query99 ="SELECT distinct agency_name FROM table_name WHERE agency_name ='' ORDER BY agency_name ASC";
$result= mysql_query($query99) or die(mysql_error());
if(isset($result))
   {
     while($row=mysql_fetch_array ($result) )
      { $_SESSION['agency_name']=$row["agency_name"];
        $agency_name=$_SESSION['agency_name'];
print "<option value=\"$agency_name\">".$_SESSION['agency_name'];
      }
    }
print "<option value=\"ALL\">ALL</option>";
?>
</select><font color=red size=4>*</font></td></tr>

Now..................
Enjoy your dynamic dropdown list :D