[thesite] most commented on articles

Warden, Matt mwarden at mattwarden.com
Thu May 24 21:56:35 CDT 2001


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

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.


cool?




- --
mattwarden
mattwarden.com

-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com>

iQA/AwUBOw3KD3gH0dUmEhrcEQLb9QCcDOZueWsGjPh6yNm9pCsiT/7sHEgAnRur
o2608aVkwwlTpqB4dUQ9kVaf
=gt1O
-----END PGP SIGNATURE-----






More information about the thesite mailing list