LinuxQuestions.org - SELECT data from Table

Im retrieving data on DropDown menu as below way. But I would like that when someone select some option on the Drop menu then show all the data that corresponse to the selected option, and display results as a list or table.. How can do that? Thanks lot..

PHP Code:




<FORM NAME="frmMenu" OnSubmit="jumptourl()">      
<SELECT NAME="SELECT" OnChange="frmMenu.submit()">  
 
<?php  
$link = OpenConnection();  
  $result = mysql_query("SELECT * FROM Campeonatos ORDER BY 'sort' ASC");  
 
  while($row = mysql_fetch_array($result))  
  {  
    /* display menu items  */  
    echo '<OPTION VALUE="' . $row[campeonato] . '">' . $row[campeonato] . "</OPTION>";  
  }  
 
CloseConnection($link);  
?>  
 
</SELECT>  
</FORM>  
 
<SCRIPT LANGUAGE="JavaScript">  
  function jumptourl()  
  {  
    window.location = './index.php?m=' + frmMenu.SELECT + '&s=0';  
  }  
</SCRIPT>