RE: [PHP] mysql query on timestamp
| From: | Jason Murray | Date: | Thu, 14 Sep 2000 03:55:19 +0000 |
| Subject: | RE: [PHP] mysql query on timestamp | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-16681@lists.php.net to get a copy of this message | ||
> How can I search a mysql database every 15 min using timestamp to see
> if there is a new entry. I will be running this at root using cron and
> php compiled as a cgi on a Linux box. What I need is the query
> statement to do this
Handy hint: SELECT UNIX_TIMESTAMP(your-timestamp-field) AS timestamp.
Then compare this to a known unix timestamp.
Jason