RE: [PHP-DB] dates in MYSQL
| From: | Ruprecht Helms | Date: | Wed, 17 Apr 2002 09:41:40 +0000 |
| Subject: | RE: [PHP-DB] dates in MYSQL | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-18590@lists.php.net to get a copy of this message | ||
Hi Alex Francis,
>
SELECT From the database WHERE date >= todays date.
^ somethink like now() or date()
an other method you put the date in a variable that you get by the
datecommand and make
SELECT From <table> WHERE date >= datevar (variable with current date)
Regards,
Ruprecht
----------------------------------
E-Mail: Ruprecht Helms <rhelms@mayn.de>
Date: 17-Apr-02
Time: 11:37:25
to be informed -> http://www.rheyn.de <-
This message was sent by XFMail
----------------------------------