changing the order of pics when editing them

[suprsonika]

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

[Nibbler]

make it ORDER BY pid DESC

[suprsonika]

Thanks, it worked. You rock!

Sarah