update form design question.

From: Date: Wed, 25 Apr 2001 20:20:48 +0000
Subject: update form design question.
Groups: php.general 
Request: Send a blank email to php-general+get-50351@lists.php.net to get a copy of this message
Basically I am just trolling for some thoughts on how others may accomplish this task. I have a mysql database. In the database I of course have records. These records have a date field and after so many days I have a script to delete old records. Now, there are often times when a user will want to "refresh" one or more records and also delete one or more as well and possibly not do anything to other records. My initial thought was to have thier records displayed with 2 checkboxes, one to check to delete the record and one to check to refresh(renew the record by setting the date field to the current date). Not checking either will simply do nothing to the record in question. Most users will have anywhere from 50 to 3000 records and 3k records would be a little unwieldy to display on one page which brought up a concern for how to handle the processing of the previous page of records when you head to the next. Should I update the DB as I move to the next page or perhaps after all pages are viewed? Anyways, any thoughts, ideas and or suggestions are all welcome. -- Larry H

« previous php.general (#50351) next »