Re: PHP SQL Code
| From: | Philip J. Newman | Date: | Sun, 02 Mar 2003 17:14:48 +0000 |
| Subject: | Re: PHP SQL Code | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-137788@lists.php.net to get a copy of this message | ||
This one returns a 'Could not get Query' warning ... so thats out.
----- Original Message -----
From: "John W. Holmes" <holmes072000@charter.net>
To: "'Philip J. Newman'" <newmanpj@philipnz.com>;
<php-general@lists.php.net>
Sent: Monday, March 03, 2003 5:31 AM
Subject: RE: [PHP] PHP SQL Code
> > 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";
>
> ---John W. Holmes...
>
> PHP Architect - A monthly magazine for PHP Professionals. Get your copy
> today. http://www.phparch.com/
>