How can I find database records that were NOT just updated
| From: | Slavko Dervisevic | Date: | Sun, 19 Nov 2000 02:08:45 +0000 |
| Subject: | How can I find database records that were NOT just updated | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-26092@lists.php.net to get a copy of this message | ||
add new field to table "updated"
add, update set these fields to 1
simple sql now finds all records not updated
after display, just run new new query and set all updated to 0
OK, let me first explain what I'm trying to do:
I have a table with about 100 records. Each record has a unique ID.
A script then adds records to this table, or updates the record if it
already exists (based on the ID).
I then need to get a list of all the records that were NOT just
inserted or updated.
Anybody have a more efficient way of doing this?
=====================
Slavko Dervisevic
Agencija INSIDE
http://www.unovomsadu.com/