you have no WHERE clause in your query.
""Ron Piggott"" <ron.pigg...@actsministries.org> 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_anagrams_rss_feed`.`rss_feed_date` and the previous 6 calendar days 
(for a total of 7 days).  What I am trying to figure out is the average of 
how many times the anagrams RSS Feed were accessed between June 1st and 7th, 
June 2nd and 8th, June 3rd and 9th, etc.

- There is 1 row for each date in the table bible_anagrams_rss_feed.
I tried the following syntax, but it is giving me an overall average, not by 
the date ranges:



SELECT AVG(`bible_anagrams`.`views`) AS average_views FROM `bible_anagrams` 
INNER JOIN `bible_anagrams_rss_feed` ON `bible_anagrams`.`reference` = 
`bible_anagrams_rss_feed`.`bible_anagrams_reference` ORDER BY 
`bible_anagrams_rss_feed`.`rss_feed_date` DESC LIMIT 7




I am wanting the query I am asking help for to be included as one of the 
mySQL results, where I have indicated "AVERAGE VIEWS QUERY HERE" (although 
if there is a better way I am opening to learning it):



SELECT `bible_anagrams_rss_feed`.`rss_feed_date` , 
`bible_anagrams`.`reference`, `bible_anagrams`.`bible_anagram_word` , 
`bible_anagrams`.`views` ,

(

AVERAGE VIEWS QUERY HERE

) AS average_views

FROM `bible_anagrams_rss_feed` INNER JOIN `bible_anagrams` ON 
`bible_anagrams`.`reference` = 
`bible_anagrams_rss_feed`.`bible_anagrams_reference`
ORDER BY `bible_anagrams_rss_feed`.`rss_feed_date` DESC



Thanks for helping me,

Ron

The Verse of the Day
"Encouragement from God's Word"
http://www.TheVerseOfTheDay.info



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to