01.<script language="javascript" type="text/javascript">
02.function changeSel(sizeId, Pname)
03.{
04. var sqlPrice= "SELECT Product_Prices FROM Product WHERE Product_Name=Pname AND Size_Id=sizeId";
05. var resultPrice=mysql_query($sqlPrice);
06. document.getElementById('Pprice').value=resultPrice;
07.}
08.</script>
09.
10....
11....
12....
13.
14.echo "<div align='left'> <select name='Psize' id='Psize' onchange='changeSel(this.value, $Pname)'>";
15. $sql = "select * from size";
16. $dbquery = mysql_db_query($dbname, $sql);
17. $num_rows = mysql_num_rows($dbquery);
18. $i=0;
19. while ($i < $num_rows)
20. {
21. $resultSize = mysql_fetch_array($dbquery);
22. $size_id = $resultSize[Size_Id];
23. $size_name = $resultSize[Size_Name];
24. print "<option value=$size_id> $size_name </option>";
25. $i++;
26. }
27. echo "</select> </div>";
28. echo "<div id=product>Price: <br><input type='text' name='Pprice' value='$Pprice'></div>";
