Getting rows where column has changed?

From: Date: Sun, 27 Oct 2002 06:33:41 +0000
Subject: Getting rows where column has changed?
Groups: php.db 
Request: Send a blank email to php-db+get-22724@lists.php.net to get a copy of this message
I'm trying to make a page to help in detecting people using automatic refresher programs. In the table that stores user info, there is a column called "lastseen" which says when the user was last seen. I'm trying to: 1. Select all lastseen colmns that are less than 5 minutes old 2. Wait 2 seconds 3. Select lastseen columns that have changed since step 1, and display that info Any ideas on how to do this? Is it even possible? Thanks... -- The above message is encrypted with double rot13 encoding. Any unauthorized attempt to decrypt it will be prosecuted to the full extent of the law.

« previous php.db (#22724) next »