How can I find database records that were NOT just updated

From: Date: Sun, 19 Nov 2000 05:00:13 +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-26102@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/

« previous php.general (#26102) next »