How to get the selected option value of a drop down list and post it to next page

[toleen]

hi all

i have a drop down list to lets user to select one option
then, i want to post this option to another page and display information from my database based on this option

how can i do this?

hint: the values of the list is stored in my database

[toleen]

anyone can help???????

[boomop]

<form action="yourpostedtopage.php" method="post">
<select name="yourselectbox" id="yourselectbox">
			<option value="something1">Option 1</option>
                        <option>Option 2</option>
</select>
<input name="submitbutton" type="submit" value="submit" />
</form>

yourpostedtopage.php

...
$selectedoption = $_POST['yourselectbox'];
...
echo $selectedoption;
mysql_query(".... WHERE column = '$selectedoption' ... ")
...

something like that?

[kakamani]

thanks for helping me in my work

[jetkingvinay]

Thank alot for this post it is very helpfull my project