Re: [PHP] Mysql Curdate problem

[Jimmy]

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 the only way to live life 
completely.


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP] Mysql Curdate problem

[Andras Kende]

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





-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]