Author Topic: sorting images by name problem  (Read 2966 times)

0 Members and 1 Guest are viewing this topic.

Offline hamstahue

  • Pre-Newbie
  • Posts: 1
    • View Profile
sorting images by name problem
« on: June 17, 2006, 01:50:32 PM »
Hi,

I'm trying to sort my photos by name but can't get it quite how i want.

The images are named photo1, photo2 etc.

If i try to sort by name they appear in order like:

photo1
photo10
photo11
photo12
photo2
photo3
...

Is there some way put them in order like:

photo1
photo3
photo4
...
photo9
photo10
photo11
...

I expect i will have to edit the code to get it how i want, but im not that experienced in website coding.
Can anyone help? or does it require too many changes.

thanks

Offline V@no

  • If you don't tell me what to do, I won't tell you where you should go :)
  • Global Moderator
  • 4images Guru
  • *****
  • Posts: 17.849
  • mmm PHP...
    • View Profile
    • 4images MODs Demo
Re: sorting images by name problem
« Reply #1 on: June 17, 2006, 02:41:37 PM »
Unfortunetly MySQL does not support "natural" sorting...
Your first three "must do" before you ask a question:
Please do not PM me asking for help unless you've been specifically asked to do so. Such PMs will be deleted without answer. (forum rule #6)
Extension for Firefox/Thunderbird: Master Password+    Back/Forward History Tweaks (restartless)    Cookies Manager+    Fit Images (restartless for Thunderbird)