pulldown menu + onChange

manjeman

hi there,

i've got a problem here where i have a script of pulldown menu, listed all product extract from mysql database. what i want is, when i select one of the product from the menu (using onChange), the price of the selected product will show in the same page. i've got the problem how to display..the price...
plezz..plezz..somebody..help me to settle this problem..

techek

First of all, PHP is a serverside-\"thing\" which means that anything you want to happen (interact) on your webpage locally will and can be made the ordinary way (without PHP).

I suggest you take a look at JavaScript FAQTS ( http://www.faqts.com/knowledge_base/index.phtml/fid/53 ) about the onChange-event.

Also, if you could be more specific on which way you\'d like to \"show the price\". Several ways can be implemented eg. DHTML, iframes/layers, CSS and so on ...

/Jacob

Anon

Sorry about this explanation, I don't have the code I used here so I will try and explain it.

What you need to do is onchange run a javascript function. In the script get the value of the selected item.(When you create the drop down box have the text be the product name and the value be the price)
Create another form in your page and the field that you want the price inserted into.
Back in the javascript, set the new text field to your selected item value.

If this is too vague, which I am sure this is, and I don't come back and post an example, feel free to e-mail me.

manjeman

here is my coding...there's no problem to display the product name but i'm still confusing how to display the product price when i select product name.i want the price display in the somewhere in the same place..

anyone can help me pleeeezzzz...

<TR>
<TD BGCOLOR="<?=$BG_COLOR_SECONDARY ?>">
<FONT COLOR=<?=$FONT_COLOR_PRIMARY?>>Product:</FONT></TD>
<TD>

<INPUT TYPE=HIDDEN NAME=PRICE VALUE=$row[2]>
<SELECT onChange=document.custq.submit() NAME=prodlist>
<OPTION SELECTED>Choose Product</OPTION>
<?

require("globals.inc");

$query = "SELECT p_id, p_description, p_price, p_stock_quantity
FROM product
ORDER by p_id";
$db = new Db;
$db->query($query);

$mysql_result= mysql_query($query);
while ($row = mysql_fetch_array($mysql_result)) {
echo("<OPTION VALUE=$row[0]>$row[0] $row[1]</OPTION>");
}
?>
</SELECT>

</FORM>
</TD>
</TR>