On Sun, Jan 30, 2011 at 2:27 PM, Ron Piggott <ron.piggott@xxxxxxxxxxxxxxxxxx> wrote: > > I have a question about the mySQL query below. The purpose is to find the last 15 days Bible reading for an RSS feed. > > In the table each day’s reading is assigned the day # in the year (between 1 and 365). But if the query is ran on January 6th, for example, it will only find 6 rows in the result. Is there a fancy way to ensure a total of 15 rows are retrieved, even if some of the rows from the end of the year (days 350 to 365) are being displayed, so it is like a loop? (I have a record in the table for day 366 for ‘leap year’ that says the Bible reading starts again tomorrow, for when it is needed every 4th year) > > Ron > > === > > $day_of_year = getdate(); > > #add 1 because yday starts at 0 > $day_of_year = $day_of_year[yday] + 1; > > $query="SELECT * FROM `$database1`.`friends_of_the_ministry_Bible_reading_plans` WHERE `plan` =1 AND `day` <= $day_of_year ORDER BY `day` DESC LIMIT 15"; > > === > > The Verse of the Day > “Encouragement from God’s Word” > http://www.TheVerseOfTheDay.info > Ron, Why not do a mktime for -15 days...that should cover the calendar back into last year www.php.net/mktime -- Bastien Cat, the other other white meat -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
