[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
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
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
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
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.
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.
You can see a fake sample of this at: www.aiaky.org/articles.htm
I have the following $query on the actual e-news page:
$query_rsENews = 'SELECT *
6 matches
Mail list logo
