Setting the sort order of thumbnails on the seach results page

[ejgladwin]

Hello,

I installed Coppermine 1.3.2 and I have modified it quite a bit to make it work the way I want.  The only thing I'd like to do which I haven't been able to do, is change the sort order of the thumbnails for the search results page.

I'd like the thumbnails for search results to be ordered so that the most recently uploaded files are shown first.  At the moment it seems at though it is showing the earliest thumbnails first, and the most recent thumbnails last (or it could also be name ascending).

I tried changing the default sort order in the Coppermine config screen but this doesn't seem to affect how the search results are ordered.

Thanks in advance for any help,

Edward ~

http://photos.edgladwin.com/

[Nibbler]

You'll need to hardcode it, look in include/search.inc.php, find:

Code Select Expand

$sql = "SELECT $select_columns " . "FROM {$CONFIG['TABLE_PICTURES']} " . "WHERE ($pic_set) " . "AND approved = 'YES' " . "$ALBUM_SET $limit";

and change to

Code Select Expand

$sql = "SELECT $select_columns " . "FROM {$CONFIG['TABLE_PICTURES']} " . "WHERE ($pic_set) " . "AND approved = 'YES' " . "$ALBUM_SET ORDER BY pid DESC $limit";

[ejgladwin]

Thanks very much, that worked perfectly