keep a variable from a mysql generated drop down

[peehaichpee]

hey all

so I have this bit down:

$query="SELECT `2010 Region Code` AS codes FROM locations";

$results = mysql_query($query);


$options="";

$options = "<select location='codes'>";
while($nt=mysql_fetch_assoc($results))
{

$thing=$nt["codes"];

$options.="\r\n<option value ='{$nt['codes']}'>
{$nt['codes']}</option>";
}
$options .="\r\n</select>";
echo $options;

 

what I'm trying to do is grab the selection from the drop down and display it as a table (the sql query would be extended should we manage to figure this one out

 

I've tried

echo"<form name='LOCATIONS' action='".$_SERVER['PHP_SELF']."' target='iframe' method='post'>";

any ideas?

[dragon_sa]

this is a javascript question, you dont need the form part

 

$options.="<option value =\"page.php?code={$nt['codes']}" onchange=\"window.open(this.options[this.selectedIndex].value,'myIFrame')\">{$nt['codes']}</option>\r\n";

 

Give the iframe the name myIframe, create another page in this example called page.php and setup your table, the variable $_GET['code'] in this example will be available on the page.php page for you to build your table from