What is the best way to do the following:
I have queried the database for a set of records that I am presenting to the user in an HTML table. At the bottom of the table is a total. The first column of the table is a check box which needs to allow the user to select and unselect records that should be included in the total at the bottom.
I need to have the total change as the user checks or unchecks the various checkboxes. I don't need to requery that database.
Once the user is finished checking and unchecking boxes, I know how to process the results in a followup script.
The part about updating the totals is confusing, however. I don't want to have to update the database and requery (unless I have to).