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]