fill form element from nother element with info in db

rtown

just trying ot figure out how you would fill a form element based on the selection of another element within the same form. I have a dropdown of sizes, but the price to be displayed is dependant on the size, so once a size is selected I need to go to the db find that product name and that size and pullout the corresponding price...not sure how to go about that, someone mentioned javascript...I don't know, I do realize that the page will have to be reloaded after selected the size, but how can you make this flow nicely without making every page seem choppy everytime you click something????

thanks in advance!

stolzyboy

javascript is the only way you are gonna achieve that without reloading the pages, and that itself will make it seem clunky

Sxooter

There's a solution here on the site, not sure how good it is, as I haven't played with it.

http://www.phpbuilder.com/snippet/detail.php?type=snippet&id=491

I've found it easier, and generally faster, to just rebuild the whole form in this situation. I had a demo of it, but you can figure it out probably. You just need a

on.change(submit) type thing in your first select box.

rtown

thanks guys, should be able to do something with that example...I'll mess around with it a little. Off hand, since the morning is bringing a mental block for me, how can I have a default size (selected in my dropdown) and the corresponding price to that size for when someone goes to the page, so that at least something is showing, then if they change the size the price will change..any ideas? Here is how I have the stuff displayed as of now:

$sp_query=@("SELECT s_size,s_price,price_per FROM size WHERE prod_name = '$prod_name'");

<td width="13%" height="33">
<div align="right"><font color="#666633" face="ParkAvenue BT" size="+1"><b>Size:</b></font></div>
</td>
<td width="19%" height="33">
<div align="left">
<select name="size" size="1">
<?php
while($sp=mysql_fetch_array($sp_query)){
$size=$sp["s_size"];
echo ("<option value='$size'>$size</option>");
}
?>
</select>
</div>
</td>
<td width="19%" height="33">
<div align="right"><b><font color="#666633" size="+1" face="ParkAvenue BT">Price:</font></b></div>
</td>
<td width="21%" height="33">
<div align="left">$</div>
</td>

so I need the first item on the size dropdown to be selected, not sure with the while loop, maybe an array???drop in element 0, then start loop at 1??? but then to grab the price relating to size[0] and fill the cell where price is to be for a default.

Thanks in advance if you get time, thanks again for the link!
cheers...