[thesite] most commented on articles

[Michele Foster]

Hey Matt.....

I like your suggestion .. my only concern would be .. is there enough room
to show all 15 comments on the side bar?  and if not, which I don't think
there will be, can the "MORE" lead to a more useful page, i.e. one sorted
chronologically .. it isn't at the moment.

My suggestion ..... on the side bar, show the latest 5 comments .. within
MORE, show the additional 10 .... then a link to the form for searching for
a comment.

Right now, its returning 1564 comments .. not sure what order they are in...
appears to be by Topic (should be changed to category), then by date, but
the Next Comment link keeps returning the same page.


Michele
(*please don't shoot me* <G>)


----- Original Message -----
From: "Warden, Matt" <mwarden at mattwarden.com>


| last time this was brought up, no one but rudy said anything.
|
| I've thought more about it and I have a slightly different approach
| than i did before.
|
| For those of you just joining us, this is concerning the "Most
| Commented On Aritlces" boxen that is fairly static (even though it's
| being built out of the database). Just the nature of the box causes
| there to be little rotation.
|
| Last time I suggested adding a where condition in the SQL that
| limited the items in that box to the last X days. I've kinda changed
| my mind.
|
| How about if the query is something like:
|
| select the articles where numberOfComments >= 15 ORDER BY datemod
| DESC
|
| This way, it will direct users to new hot discussions and the top
| article in this box will be the latest hot discussion.
|
| I can make the change. I just want some feedback before I go changing
| stuff.