Mysql Curdate problem
| From: | Andras Kende | Date: | Wed, 02 Jan 2002 00:56:32 +0000 |
| Subject: | Mysql Curdate problem | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-79192@lists.php.net to get a copy of this message | ||
Hello,
I have a php page which list a table from a mysql database.
Dates can be selected like last 7 days, last 14 days .etc....
It worked perfect till midnight :(
The query is something like:
$aresult=mysql_query("select * from orders WHERE (a3 >= CURDATE()-$datec)"
,$db);
I looking for some advice hos to modify my query or the php code..
Thanks
Andras Kende