Re: Help with AVG()
| From: | Jim Giner | Date: | Tue, 14 Jun 2011 12:57:25 +0000 |
| Subject: | Re: Help with AVG() | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-47856@lists.php.net to get a copy of this message | ||
Why not try setting vars to the date values you wish to select and use them
in your where clause? You may have something wrong in this complex syntax.
Something like:
$st_date = today() ??
$end_date = $st_date less 7 days ??
Where rss_feed_date >= $st_date and rss_feed_date <= $end_date
btw - why not use table aliases to save on typing and improve readability?
""Ron Piggott"" <ron.piggott@actsministries.org> wrote in message
news:82DDACD57AB849159889CB7C6A3FFAAB@RonPiggottPC...
bible_anagrams_rss_feed.rss_feed_date BETWEEN
bible_anagrams_rss_feed.rss_feed_date AND DATE_SUB(
bible_anagrams_rss_feed.rss_feed_date , INTERVAL -1 WEEK )