Re: [PHP-DB] RSS Feed

2011-01-30 Thread Ron Piggott
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.

Re: [PHP-DB] RSS Feed

2011-01-30 Thread Bastien Koert
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 o

[PHP-DB] RSS Feed

2011-01-30 Thread Ron Piggott
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