RE: [PHP-DB] Date Select help
| From: | John Holmes | Date: | Mon, 23 Sep 2002 11:02:10 +0000 |
| Subject: | RE: [PHP-DB] Date Select help | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-21928@lists.php.net to get a copy of this message | ||
> Any one have any information on selecting a rake of dates from a mysql
> database?
>
> my current query reads.
> $result = mysql_query("SELECT * FROM CWC_Memory");
>
> I neeed to select where date is between todays date and todays date
+10.
SELECT * FROM CWC_Memory WHERE date_column BETWEEN NOW() AND NOW() +
INTERVAL 10 DAY
---John Holmes...