[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

Re: [PHP-DB] RSS Feed

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

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.