Calcualting a figure
Posted: Thu Feb 24, 2005 4:06 pm
Hye
I'm building an online ordering system for a project at Uni, What I'm attempting to do is calcualte a figure based on the quantity and price. At the moment the user selects from a series of radio buttons which then uses the value to lookup in another table the item description and then inserts that details along with other user entry such as the quantity into an order table. The item table does contain a value for price.
What my question is how would i go by calculating the two togeother and then inserting that value into the order table along with the other details which are currently being passed.
Would a function need to be implemented or something else?
Hope someone can help

I'm building an online ordering system for a project at Uni, What I'm attempting to do is calcualte a figure based on the quantity and price. At the moment the user selects from a series of radio buttons which then uses the value to lookup in another table the item description and then inserts that details along with other user entry such as the quantity into an order table. The item table does contain a value for price.
What my question is how would i go by calculating the two togeother and then inserting that value into the order table along with the other details which are currently being passed.
Would a function need to be implemented or something else?
Hope someone can help