RE: [PHP] tweeking WHERE clause

2004-05-05 Thread Jay Blanchard
[snip] > Do a count of this monthes articles, if NONE, then run another query to > select the previous months articles. Note, this would only "publish" this > or last monthes records. [/snip] Another thing that you could do is get all articles sorted in reverse order for the last 60 days using DA

Re: [PHP] tweeking WHERE clause

2004-05-05 Thread msa
That would work. "Daniel Clark" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > OK how about. > > Do a count of this monthes articles, if NONE, then run another query to > select the previous months articles. Note, this would only "publish" this > or last monthes records. > -- PHP

Re: [PHP] tweeking WHERE clause

2004-05-05 Thread Daniel Clark
OK how about. Do a count of this monthes articles, if NONE, then run another query to select the previous months articles. Note, this would only "publish" this or last monthes records. > there are a different number of articles each month...:( > > "Daniel Clark" <[EMAIL PROTECTED]> wrote in me

Re: [PHP] tweeking WHERE clause

2004-05-05 Thread msa
there are a different number of articles each month...:( "Daniel Clark" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hey Melissa. > > Will your articles always had a certain number (for each section) each > month? If so a ORDER BY and LIMIT would work. > > Daniel -- PHP Genera

Re: [PHP] tweeking WHERE clause

2004-05-05 Thread Daniel Clark
Hey Melissa. Will your articles always had a certain number (for each section) each month? If so a ORDER BY and LIMIT would work. Daniel > I am trying to query a table that consists of e-news artilces. in the > table > are the following fields: ID, sortBy, datePublished, title, description.