[thesite] add: LOTTD

[Warden, Matt]

On Sep 21, Dean Mah had something to say about Re: [thesite] add: LOTTD

>Well I don't know if there's anything wrong with it, per se.  However,
>it returns a lot of articles, 19, but the front page only shows, 10.
>
>How many is it supposed to return?  Should it be limited to 10?  Or is
>it limited by date?  Inquiring minds want to know.

Lazy inquiring minds?  =)

select
        content.contentid, content.contentname, content.body,
        content.datemod, users.userid, users.who,
        categorys.category, categorys.categoryid
from content,users,categorys
where content.signoff=1
and content.userid=users.userid
and content.datemod > '#dateformat(lastweek, "dd-MMM-yyyy")#'
and content.categoryid=categorys.categoryid
and content.categoryid <> 26
order by content.datemod desc

the line you wanna look at is:

and content.datemod > '#dateformat(lastweek, "dd-MMM-yyyy")#'


So, it's the articles with a datemod within the last week... I suppose.


So's, youns got issues?


--
mattwarden
mattwarden.com