General Support: Sorting Collections in alphabetical order

Gallery.php, line ~542:
$sql = "SELECT * FROM `".$TABLE_PREFIX."collections` WHERE id IN ($imlist) LIMIT ".$from.",".$config["thumb_num"];

Change to SOMETHING like below:
$sql = "SELECT * FROM `".$TABLE_PREFIX."collections` WHERE id IN ($imlist) LIMIT ".$from.",".$config["thumb_num"] . " ORDER by 'name'";

Don't know if it'll work, it depends on whether (1) that's the sql actually determining the order of the collections, (2) the SQL syntax and whether I'm putting it in the right place. I'm certain, but it's worth a shot. Mike and Anti would have a better idea. I've actually mutilated my collections view, so I can't test myself.

Best of luck,
Derek

Try this (this is for albums, but you can use the same technique for collections):

$sql = "SELECT * FROM `".$TABLE_PREFIX."albums` WHERE `parent_id` = '$id' AND id IN ($imlist) ORDER BY `name` DESC LIMIT

change DESC to ASC (descending to ascending order)

Debbie

Hi all,

ddejong - I found the line but that edit doesn't seem to work... I get the following error on the main page of the gallery:

"You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '20ORDER by 'name'' at line 1

SELECT * FROM `plogger_collections` WHERE id IN (-1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,33,34,35,36,37,38,39,40,41) LIMIT 0,20ORDER by 'name'"

kanjigirl - That sorts the albums out alright, but I want to sort the collections by alphabetical order rather than the order in which they were created, which is what it seems to be doing.

Thanks again,
Dan

I dunno what's going on... I am using the exact line ddejong gave me and as soon as I use that line, I get this error :/ Everything seems to be ok. Here's the are of code:

// I need to determine correct arguments for LIMIT from the given page number

$from = ($page - 1) * $config["thumb_num"];

$sql = "SELECT * FROM `".$TABLE_PREFIX."collections` WHERE id IN ($imlist) LIMIT ".$from.",".$config["thumb_num"] . " ORDER by 'name'";
$result = run_query($sql);

Dan

I think your parameter order is messed up, "ORDER by" should precede the LIMIT parameter.

So your SQL statement should read:
SELECT * FROM `plogger_collections` WHERE id IN (-1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,33,34,35,36,37,38,39,40,41) ORDER by 'name' LIMIT 0,20

Seriously, Dan, you're too close to give up. Just copy and paste what Mike has above; it should work just fine.

Derek

MySQL isn't happy with where you put the ORDER clause. Don't think of it as programming, just grammar (syntax).

Find the line you replaced my initial code (faulty). Replace it with this:
$sql = "SELECT * FROM `".$TABLE_PREFIX."collections` WHERE id IN ($imlist) ORDER by `name` LIMIT ".$from.",".$config["thumb_num"]";

Sorry, when I gave the initial "something like this" code, I didn't even know 'name' was an actual field in the table or that mySQL wouldn't take the ORDER clause after LIMIT. I was trying to give you a general idea of how to go about it. This (above) is exactly how to do it.

Regards,
Derek

*ignore this*