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?
Ron
The Verse of the Day
“Encouragement from God’s Word”
http://www.TheVerseOfTheDay.info
-----Original Message-----
From: Bastien Koert
Sent: Sunday, January 30, 2011 4:10 PM
To: Ron Piggott
Cc: php-db@lists.php.net
Subject: Re: [PHP-DB] RSS Feed
On Sun, Jan 30, 2011 at 2:27 PM, Ron Piggott
<ron.pigg...@actsministries.org> 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
