RE: [PHP] tweeking WHERE clause
| From: | Jay Blanchard | Date: | Wed, 05 May 2004 17:07:10 +0000 |
| Subject: | RE: [PHP] tweeking WHERE clause | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-185453@lists.php.net to get a copy of this message | ||
[snip]
> Do a count of this monthes articles, if NONE, then run another query
to
> select the previous months articles. Note, this would only "publish"
this
> or last monthes records.
[/snip]
Another thing that you could do is get all articles sorted in reverse
order for the last 60 days using DATE_SUB in the query.