php/mysql drop down boxes

[tom_e]

Hi, quick question I've managed to create a drop down box which pulls the info from a table to populate itself. Can anyone point me in the right direction for getting it to load another page with the selected info.

My drop down box code is

$res=mysql_query("SELECT * FROM nutrition order by goal") ; 
echo "<select name=myselect>"; 
while($row=mysql_fetch_assoc($res)) { 


echo "<option value=$row[ID]>$row[goal]</a></option>"; 
} 
echo "</select>";