how to transfer the value of a dropdown where the dropdown's value came from the database?
<p>how to transfer the value of a dropdown where the dropdown's value came from the database?</p>

<p>here is my code..</p>

<pre><code>&lt;?php


$con = mysql_connect("localhost","root","");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

mysql_select_db("thesis", $con);

@$setup=$_GET['pqsetup'];

?&gt;
&lt;form id="form1" name="form1" method="post" action=""&gt;
&lt;table width="414" border="1" align="center"&gt;
&lt;tr&gt;
&lt;td width="84" class="style1"&gt;
Set-Up: &lt;/td&gt;

&lt;td width="9"&gt;
&lt;td width="49"&gt;
&lt;?php

$pqsetupquer = mysql_query("SELECT * FROM pqsetup");

echo "&lt;select name='pqsetup' onchange=\"reload(this.form)\"&gt;";
echo "&lt;option selected&gt;---------------------&lt;/option&gt;";
while($noticia2 = mysql_fetch_array($pqsetupquer)) { 

if($noticia2['pqs_no']==@$setup){

echo "&lt;option value='$noticia2[pqs_no]' selected&gt;$noticia2[pqs_name]&lt;/option&gt;"."&lt;BR&gt;";
}else
echo "&lt;option value='$noticia2[pqs_no]'&gt;$noticia2[pqs_name]&lt;/option&gt;"."&lt;BR&gt;";

}
echo "&lt;/select&gt;";


?&gt; &lt;/td&gt;
&lt;td width="142"&gt;Menu Packages&lt;/td&gt;
&lt;td width="32"&gt; &lt;?php

$menuquer=mysql_query("SELECT pqs_no, menu_name FROM menu_packages");


//echo "&lt;select name='menu_name' onchange=\"reload(this.form)\"&gt;";
echo "&lt;select name='menu_name'&gt;";
echo "&lt;option selected&gt;---------------------&lt;/option&gt;";

while($noticia = mysql_fetch_array($menuquer))
{       
    if($noticia['pqs_no']==@$setup)
    {
        echo "&lt;option value='$noticia[pqs_no]' selected&gt;$noticia[menu_name]&lt;/option&gt;"."&lt;BR&gt;";       
    }
    else
        //echo "&lt;option value='$noticia2[pqs_no]'&gt;$noticia[menu_name]&lt;/option&gt;"."&lt;BR&gt;";
        echo " ";


}
echo"&lt;/select&gt;";

?&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;/table&gt;

&lt;/form&gt;
</code></pre>

<p>how can i transfer the value and just display it in another page??</p>
