PDA

View Full Version : Why Does Ordering A-Z Not Sort Correctly?



retrosprite
11-28-2015, 06:59 PM
I noticed the sorting function does not sort the way I think it should when it comes to numbers in the title for example, wallpapers with numbers in the title look like this when sorting A-Z:

Wallpaper 19
Wallpaper 2
Wallpaper 20

and

Wallpaper 29
Wallpaper 3
Wallpaper 30

It should just list them 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, and so on but instead the wallpapers with single digit numbers are not placed at the beginning but moved like I showed above.


Another thing, when bulk importing wallpapers I would like to be able to import them alphabetically instead of what seems to be random. I would guess the order they are imported is based on the upload date.

Andy
12-01-2015, 06:22 PM
This is what happens when you order by name in MySQL and as far as I know, there's not a very simply way to change that. I'm afraid it's something you will likely have to put up with I'm afraid.

retrosprite
12-01-2015, 06:36 PM
This is what happens when you order by name in MySQL and as far as I know, there's not a very simply way to change that. I'm afraid it's something you will likely have to put up with I'm afraid.

Thanks for the info, it's not that annoying.