Bastien I have been wondering about this approach this afternoon, but I don't know how to do it. What is throwing me off is the structure of the database. There is no year in it. Only the column "day" is a number from 1 to 366 (See table structure, below)

I get that you are saying though. If it is between January 1st and 15th the remaining records are in December of the previous year.

CREATE TABLE IF NOT EXISTS `friends_of_the_ministry_Bible_reading_plans` (
 `reference` int(4) NOT NULL AUTO_INCREMENT,
 `plan` int(2) NOT NULL DEFAULT '0',
 `day` int(4) NOT NULL DEFAULT '0',
 `assigned_reading` varchar(65) NOT NULL DEFAULT '',
 `content_summary` varchar(500) NOT NULL,
 PRIMARY KEY (`reference`)

Are you able to offer me some more help with this table structure?


The Verse of the Day
“Encouragement from God’s Word”

-----Original Message----- From: Bastien Koert
Sent: Sunday, January 30, 2011 4:10 PM
To: Ron Piggott
Subject: Re: [PHP-DB] RSS Feed

On Sun, Jan 30, 2011 at 2:27 PM, Ron Piggott
<> 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)



$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”


Why not do a mktime for -15 days...that should cover the calendar back
into last year



Cat, the other other white meat

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to