From: "John Taylor-Johnston" <[EMAIL PROTECTED]>
> I'm creating a counter. > > I want a timestamp where I can calculate if a time stamp is older than one hour, if so do X, if not do Y. SELECT * FROM Table WHERE timestamp_column < NOW() - INTERVAL 60 MINUTE will give you all rows that have a timestamp column that's over 60 minutes old. Adapt to your needs. ---John Holmes.. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
