Drop down lists, mysql, variables

jasoncable

I have drop down lists populating form a mysql database, with an item, and what I want to happen is when the item is clicked on(in the drop down list)show the price on another cell of the table, and add all the prices up from the other drop down lists. What I have been able to do so far is to get a price to show up using java script in another cell but it shows up in the form of <span id="description"></span>
Can I create a variable that will change everytime I click on a different item like the "description" does? Or is their a way to add up all the "description" things at the end?

Thanks in advance,

statrat

not really sure what you mean. but maybe this will help?

<HTML>
<HEAD>
<script language="javascript">
var price=0.00;
function addem(obj){
  price=price+parseFloat(obj.value);
  document.frm.tex.value=price;
}
</script>
</HEAD>

<BODY>
<form name="frm">
<select name="sel" onchange="addem(this)">
<option value="2.3">2.3
<option value="4.5">4.5
<option value="6.1">6.1
<option value="8.6">8.6
</select>
<br>
<select name="sel" onchange="addem(this)">
<option value="2.9">2.9
<option value="6.4">6.4
<option value="6.7">6.7
<option value="10.8">10.8
</select>
<br>
<input type="text" name="tex">
</form>
</BODY>
</HTML>

jasoncable

With that code i cannot get it to put thoes added values into the textbox. Maybe this will clarafy. With that code, i would like to have it drop down and i pick 2.4 and that would show up in the textbox, or if i pick 2.4 from the first one and 6.7 form the next one , the sum show up in the textbox.

Thanks for the help.

stolzyboy

check out http://javascript.internet.com/forms, they may have some help for you, since this can't be done with php without submitting to a new page, it needs to be done client side, i have gotten a lot of stuff from this site, it is pretty useful, not sure if they have a forum, haven't even looked, but the examples are pretty descriptive

statrat

try it again please.

<HTML>
<HEAD>
<script language="javascript">

function addem(obj){
  document.frm.price.value=parseFloat(document.frm.price.value)+parseFloat(obj.value);
  document.frm.tex.value=parseFloat(document.frm.price.value).toFixed(2);
}

</script>
</HEAD>

<BODY>
<form name="frm">
<select name="sel" onchange="addem(this)">
<option>-- Select --
<option value="2.3">2.3
<option value="4.5">4.5
<option value="6.1">6.1
<option value="8.6">8.6
</select>
<br>
<select name="sel" onchange="addem(this)">
<option>-- Select --
<option value="2.9">2.9
<option value="6.4">6.4
<option value="6.7">6.7
<option value="10.8">10.8
</select>
<br>
<input type="text" name="tex" value="0">
<br>
<input type="reset" value="Reset">
<input type="hidden" name="price" value="0">
</form>
</BODY>
</HTML>

jasoncable

statrat,
Thank you so much! I connot express my thanks.
I'm off to code

Thanks again!

statrat

you're welcome.
one thing, i don't think that "toFixed()" javascript function works in older browsers, so you might get weird values.