Re: Getting rows where column has changed?
| From: | Ignatius Reilly | Date: | Sun, 27 Oct 2002 07:52:06 +0000 |
| Subject: | Re: Getting rows where column has changed? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-22725@lists.php.net to get a copy of this message | ||
How often in a day must you do this? Every 5mn?
Ignatius
____________________________________________
----- Original Message -----
From: "Leif K-Brooks" <eurleif@buyer-brokerage.com>
To: <php-db@lists.php.net>
Sent: Sunday, October 27, 2002 7:33 AM
Subject: [PHP-DB] Getting rows where column has changed?
> 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.
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>