i got a problem to display a total from a few data in my database
for example, in my database i got these fields:
total double; ---> should i put this in my table to save my total that will be calculated later ?
got it ? then, using a form in my web, i will insert the price for these items. then, in the total textfield, i want it to automatically display the grand total of stuff that i buy.
what is the query ? how to save it into my table ? and how to automatically display it ?
what i mean by automatically display the grand total is when i insert price into food the grand total will display the current amount.