Re: Mysql Curdate problem
| From: | Jimmy | Date: | Thu, 03 Jan 2002 03:03:58 +0000 |
| Subject: | Re: Mysql Curdate problem | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-79281@lists.php.net to get a copy of this message | ||
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.