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
I have continued to work on the average query I need help. I am still needing
help.
What I don’t understand is why
`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 )
won’t
you have no WHERE clause in your query.
""Ron Piggott"" wrote in message
news:F6C4EF096B4446CA8AECD201C1E86C39@RonPiggottPC...
Hi Everyone
I am trying to figure out how to write a SELECT query that will give me the
average of `bible_anagrams`.`views` starting on the date specified in
`bible_a