dynamic drop down menu's

[thelad]

Right heres the deal.

Im doing a map using php3.
The plan is to view the main map,
and when you click on a certain area on the map, a new page is generated with the enlarged section of the map.
The bit i'm stuck with is , that I want a drop down menu to appear with all the street names in that area. These street names will be either in a database table
or in a normal text file.This should work such that if I add a new street name to the table/file, then it would be visable in the drop down menu also.

If anyone could help a beginner,
Thanks
Alex

[Anon]

This is a real nasty bit of PHP to do, in my opinion, see if this helps.
connect.inc just connects to the database.

<?php
include "connect.inc";
$choose=mysql_query("SELECT steetname FROM tablename", $db)
?>

Map<select name="streets">
<?php
while($rows=mysql_fetch_array($choose)) {
print $rows["streetname"];
?>
<option value="<?php echo $rows["streetname"]?>">
<?echo $rows["streetname"]?></option>
<?php
}
?>
</select>

tablename is the name of the table
streetname is the field with the street names in
streets is the variable to be created, ie later on if you do

echo "$streets"; (not sure if "" are needed, sometimes they are, something not I think)

you should get the value selected, hope it helps.