RE: [PHP] PHP SQL Code
| From: | John W. Holmes | Date: | Sun, 02 Mar 2003 17:21:24 +0000 |
| Subject: | RE: [PHP] PHP SQL Code | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-137790@lists.php.net to get a copy of this message | ||
> > > I would like yo show the users in a list that have a date that is
more
> > > than
> > > 60 days old.
> >
> > $sql = "SELECT * FROM stompers WHERE sUpdated < CUR_DATE() -
INTERVAL 60
> > DAY AND sActive = 'Y' ORDER BY sUpdated DESC";
>
> This one returns a 'Could not get Query' warning ... so thats out.
Sorry, it's CURDATE(), not CUR_DATE(). Maybe you shouldn't be so quick
to rule things out...
---John W. Holmes...
PHP Architect - A monthly magazine for PHP Professionals. Get your copy
today. http://www.phparch.com/