need a select box drop down from a table

[Anonymous]

<?
/* do your select up here to get a result set */

// start the select box
echo "<select name=\"place\">\n";

// loop through your results
while($row = mysql_fetch_assoc($result)) {
   echo  '<option value="' . $row['idnumber1'] . '">' .
         $row['location'] . ',' . $row['city1'] .
         "</option>\n";
}

// close the select box
echo "</select>\n";
?>