[maxat]

Hi!
I need help in my project. I have database named "product", fields are pd_id, pd_name and price. I need to retrieve product name into combo box and based on selection display price at the same time when user selects the product. Now i can retrive data, but don't know how to display the price of selected product. Any help will be highly appreciated.

[maxat]

I dont know to make it work with java script if you have an example could you post it?
there is my current code

PHP Code:

<?php

$sql = "SELECT pd_id, pd_name, price, p.cat_id , c.cat_id, c.name

FROM product p, category c where p.cat_id = c.cat_id and c.name = 'mainboard'

ORDER BY pd_id";

$result = dbQuery($sql) or die('Can not get product list.' . mysql_error());



$options="";



while ($row=mysql_fetch_array($result)) {



$id=$row["pd_id"];

$name=$row["pd_name"];

$price=$row["price"];

$options.="<OPTION VALUE=\"$id\">".$name.'</option>';





}

?>

Code:

<table>
<tr>
<td>Motherboard</td>
<td><SELECT class="box" NAME="motherboard"><OPTION><?=$options?></OPTION></SELECT></td>
<td> $price </td>
</tr>
</table>