how to post value from drop down to textbox
<pre><code>&lt;script&gt;
    function load(form)
    &lt;?php   
    {
        $query = "SELECT roomNo, price FROM dbo.Room WHERE roomNo =  '".$_GET['roomNo']."'";
        $result = mssql_query($query) or die ("Error Query [".$query."]"); 
        $details = mssql_fetch_array($result);
        $price = $details["price"];
    }
    ?&gt;
    &lt;/script&gt;
    &lt;table width= 100% border="0"&gt;

        &lt;tr&gt;
            &lt;td&gt;List Menu&lt;/td&gt;
            &lt;td&gt;:&lt;/td&gt;
            &lt;td&gt;
                &lt;select name="opRoomNo" onchange="load(this.form)"&gt;
                &lt;? while($objResult = mssql_fetch_array($objQuery))
                {
                ?&gt;
                    &lt;option value="&lt;?=$objResult["roomNo"];?&gt;"&gt; &lt;?=$objResult["roomNo"];?&gt; &lt;/option&gt;
                &lt;?
                }
                ?&gt;
                &lt;/select&gt;
            &lt;/td&gt;
        &lt;/tr&gt;
        &lt;tr&gt;
            &lt;td&gt;Price&lt;/td&gt;
            &lt;td&gt;:&lt;/td&gt;
            &lt;td&gt;&lt;input type="text" name="txtPrice" value="&lt;? echo $price; ?&gt;" &gt;&lt;/td&gt;
        &lt;/tr&gt;
</code></pre>

<p>I can't get the value from the database on selecting the drop box.</p>
