Multiplying fields and then adding the results
Posted: Mon Aug 15, 2011 3:48 am
I am setting up a order form on my website http://www.acehireltd.co.uk/orderform/ , I have been able to pretty much set everything up including auto complete and adding space for another product when you check a box etc. However there is one last thing I need to do which I just cant work out.
Each product has a price that gets auto filled from a mysql datebase when the user enters the products name or code, the user must the enter a quantity of how many of that product they want. I need the price and quantity field to be multiplied together an the result of this displayed in another field on the form (e.g called total product price).
I also then at the bottom of the form need a complete total price to be worked out by adding all the total product prices as well as the delivery cost field.
I hope someone can help.
Thanks you.
Each product has a price that gets auto filled from a mysql datebase when the user enters the products name or code, the user must the enter a quantity of how many of that product they want. I need the price and quantity field to be multiplied together an the result of this displayed in another field on the form (e.g called total product price).
I also then at the bottom of the form need a complete total price to be worked out by adding all the total product prices as well as the delivery cost field.
I hope someone can help.
Thanks you.