On Thu, 2002-08-01 at 11:51, Matthias Saou wrote:
> Sorry, this hasn't got much to do with rpm packages directly ;-)
> My "builds" page is getting bigger and bigger, and quite messy as
> directories are listed in no particular order :
> What I'd need is to have last modification date of the directory displayed
> next to the directory name (sort of like "mplayer - Thu Aug 1 2002"), and
> the list ordered to have the most recent entries at the top.
<http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/jpackage/website/htdocs/functions.php?rev=1.6&content-type=text/vnd.viewcvs-markup>, that's what produces the list at <http://jpackage.sourceforge.net/packages.php>.  Dirs are sorted alphabetically there, but I guess sorting by date wouldn't be that hairy...

from localhost (localhost [127.0.0.1])
	by phobos.labs.netnoteinc.com (Postfix) with ESMTP id E29EB440A8
	for <jm@localhost>; Thu,  1 Aug 2002 06:38:41 -0400 (EDT)
from phobos [127.0.0.1]
	by localhost with IMAP (fetchmail-5.9.0)
	for jm@localhost (single-drop); Thu, 01 Aug 2002 11:38:41 +0100 (IST)
from egwn.net (ns2.egwn.net [193.172.5.4]) by
    dogma.slashnull.org (8.11.6/8.11.6) with ESMTP id g71AVw207862 for
    <jm-rpm@jmason.org>; Thu, 1 Aug 2002 11:31:58 +0100
from kamakiriad.com (cable-b-36.sigecom.net [63.69.210.36]) by
    egwn.net (8.11.6/8.11.6/EGWN) with ESMTP id g71ANiJ20546 for
    <rpm-list@freshrpms.net>; Thu, 1 Aug 2002 12:23:44 +0200
from aquila.kamakiriad.local ([192.168.1.3]) by kamakiriad.com
    (8.11.6/8.11.0) with SMTP id g71ANNM07389 for <rpm-list@freshrpms.net>;
    Thu, 1 Aug 2002 05:23:23 -0500
From rpm-list-admin@freshrpms.net  Thu Aug  1 11:38:42 2002

On Thu, 1 Aug 2002 10:51:56 +0200, Matthias Saou <matthias@egwn.net> wrote:
Yep.  Make sure there's a field in the database called (for example) "Updated" and when it comes time to generate the list, add "order by updated".  This'll put it in that particular order for ya.  You can also chose to order it by name, etc by changing this field.
This should be the same for both MySql and Postgressql (any modern SQL, really).  Which are you using?