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
