retrieve information from MYSQL through drop down list

[xxreenaxx1]

I have created a drop down list and it does retrieve information from mysql but now I want to use what is been selected to retrieve information.

 

How Do I do this?

 

<?php 

MYSQL_CONNECT(localhost,'root','') OR DIE("Unable to connect to database"); 
@mysql_select_db(Examination) or die( "Unable to select database");

$query=("SELECT * FROM subject");

$result=mysql_query($query) or die ("Unable to Make the Query:" . mysql_error() );
echo "<select name=myselect>";  

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

echo "<OPTION VALUE=".$row['Sub_ID'].">".$row['Sub_Name']."</OPTION>";
}

echo "</select>"; 


?>

[phppaper]

use a html form with a submit button?

[xxreenaxx1]

I know you can do something like that. I am not sure how to. Any tutorial site you can forward me to

[phppaper]

<?php

MYSQL_CONNECT(localhost,'root','') OR DIE("Unable to connect to database");

@mysql_select_db(Examination) or die( "Unable to select database");

?>

<form action="xxxx.php" method="post">

<?php

$query=("SELECT * FROM subject");

 

$result=mysql_query($query) or die ("Unable to Make the Query:" . mysql_error() );

echo "<select name=myselect>"; 

 

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

 

echo "<OPTION VALUE=".$row['Sub_ID']." >".$row['Sub_Name']."</OPTION>";

}

 

echo "</select>";

 

 

?>

 

<input type="submit" value="submit"/>

</form>