I'm trying to order the photos by date when editing them. I found this in the FAQs:
By default, the pics are shown alphabetically when you edit them. To change the sorting order to "by date", edit editpics.php and change
$result = db_query("SELECT * FROM {$CONFIG['TABLE_PICTURES']} WHERE aid = '$album_id' ORDER BY filename LIMIT $start, $count");
to
$result = db_query("SELECT * FROM {$CONFIG['TABLE_PICTURES']} WHERE aid = '$album_id' ORDER BY pid LIMIT $start, $count");
That works, but it puts the older ones first, and I want the newest ones to be listed first. Anyone know how to change it?
Sarah
make it ORDER BY pid DESC
Thanks, it worked. You rock!
Sarah