Re: [PHP] Mysql Curdate problem

Hi Andras, > $aresult=mysql_query("select * from orders WHERE (a3 >= CURDATE()-$datec)" > ,$db); what's the value of $datec? integer 7 or 14? if so then try to change it to this: "interval 7 days" -- Jimmy Love deeply and passionately. You might get hurt but it's th

[PHP] Mysql Curdate problem

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 som