populate select box with data from mysqltable
<p>How to populate select box with data from mysql table, and then move that value from one page to another.
I did a small coding, and i was able to get all the values from table, but i cant move those value to other page.</p>

<pre><code>$query1="SELECT  * FROM seat_no WHERE seatno NOT IN(SELECT seatno FROM check_in_desk)";
$result1 = mysql_query($query1);

&lt;select name="txt_seatno"&gt;
 &lt;?php

while($nt=mysql_fetch_array($result1))
{
echo "&lt;option value=$nt[id]&gt;$nt[seatno]&lt;/option&gt;";
}
&lt;/select&gt;
?&gt;
</code></pre>
