CVS Update: gleipnir

[Dan Brosemer <odin@cleannorth.org>]

Log Message:
-----------
Sort the images by upload time

Modified Files:
--------------
    gleipnir/public_html/gallery:
        index.pl

Revision Data
-------------
Index: index.pl
===================================================================
RCS file: /cvs/gleipnir/public_html/gallery/index.pl,v
retrieving revision 1.4
retrieving revision 1.5
diff -Lpublic_html/gallery/index.pl -Lpublic_html/gallery/index.pl -u -r1.4 -r1.5
--- public_html/gallery/index.pl
+++ public_html/gallery/index.pl
@@ -153,7 +153,7 @@
 
 	my $SQL = <<EOT;
 select gp.pictureid, gp.caption, gp.thumb_path from gallery_picture gp left join gallery g on g.galleryid = gp.gallery
-where ($ingroups) and gp.gallery = ? limit $limit offset $offset
+where ($ingroups) and gp.gallery = ? order by gp.uploaded limit $limit offset $offset
 EOT
 
 	my $cursor = $dbh->prepare($SQL);