Order albums alphabetically by user profile

[dwo]

Hello

I do refer to this thread http://forum.coppermine-gallery.net/index.php/topic,24420.0.html
where the solution is presented to order albums alphabetically by username.

In order to custom order the albums, I thought to write text (a, b, c, ...) in an user_profile field and then to sort alphabetically via user_profile.

Could anyone please help me to insert the right code to sort the albums via user_profile?

Just replacing with user_profile1 didnt work.

Thank you very much.

[dwo]

Sorry for double post.

Dont know where the problem was but now it works the way described.

$sql .= "ORDER BY user_profile2 ";

A nice way to sort custom.

[Joachim Müller]

Board rules still exist and apply!