how to get the value against the value selected in text box?
<p>i want to know that when i select any value from dropdown box it shows it's price in next field
example:
if i select snacks from the dropdown menu then it show its price in next field by fetching its price from database in php
items are also fetched from database
plz help me urgently</p>

<p><img src="http://i.stack.imgur.com/D58EJ.png" alt="Here is how i want when select a particular value"></p>

<p>here is the code for fetching data from db</p>

<pre><code>&lt;?php $eb = "SELECT EmployeeID,FirstName,LastName FROM employees"; $res = mysql_query($eb); 
          $no_records = mysql_num_rows($res);
          if($no_records &gt; 0){?&gt;

         &lt;select name="EnteredBy" id="EnteredBy"&gt;
         &lt;?php 
     while($row = mysql_fetch_array($res))  { 
     echo '&lt;option value='.$row['EmployeeID'].'&gt;'.$row['LastName'].",".$row['FirstName'].'&lt;/option&gt;'; 
                                               }
                            }           
 ?&gt;
          &lt;/select&gt;
</code></pre>
