drop down menu

[pietbez]

Hi, i know this is probably very basic but i have been banging my head and looking for tuts.

 

i have built a mysql php dropdown menu.

 

all displays fine. now, how do i get the menu to actualy take me to a new url?

 

the new url should be      www.mysite.com/"menu selection"

 

 

 

<?

include_once 'includes/db.php';

$result = mysql_query("select * from crimerate WHERE DISTRICT = 'Limpopo'", $con);

if (!$result) {
    die('Invalid query: ' . mysql_error());

}


$options="";

while ($row=mysql_fetch_array($result)) {

    $id=$row["id"];
    $crime=$row["CRIME"];
    $options.="<OPTION VALUE=\"$id\">$crime</option>";
}
?>


<SELECT NAME=crime>
<OPTION VALUE=0>Choose
<?=$options?>
</SELECT>

[Muddy_Funster]

you will either need to add a submit button to the form or use a javascript/AJAX onChange event handler. You also really should close that first OPTION that you hardcoded into the HTML.