Sorting by descending order?

[Ultimo]

How do i set a default setting that sorts the pictures from the first one in the category?

I notice now that when i upload pictures, it sorts by default by last uploaded.

I know there is an option to sort manually, but i would like to have it done automatically everytime as my guests wont know which is the first and last picture. so some dance pictures i take might seem to be going backwards

Is there anyway i can set the pictures for categories to display by sequence by default instead of last uploaded?

Thanks in advance

[Chuck S]

If your asking how to display them from date ascending you would need to add your own sort to the mysql sort table and set that sort in edit categories in admin as the default cause to be honest a sort like that does not exist.

Never heard of someone intentionally wanting to sort from the oldest forward.

[bdub]

I would also like to have this sorting option available without having to recode anything.

[saltyzoo]

Hmm, I too want the order reversed.

Here's why: I upload a sequence of shots from first to last, but they show up backwards - last to first. I want people to see them in the sequence they were taken.

[Chuck S]

Create some new sort in your sort table like maybe

ORDER BY id ASC

Then just set that to be the default sort in your category editor for that cat

[saltyzoo]

easy 'nuff.

Thanks. Hope things are going well with the tank.

[Chuck S]

Tank is fine thanks.

[saltyzoo]

That works quite well. In fact, I also wanted to control the exact order of some categories in a very specific way, and I can do that quite easily by creating a custom field for the images and using that as the sort order.

Thanks for pointing me in the right direction.

[MediaHound]

Me three lol

I have a member who wants his photos sorted from oldest to newest, it's a photo sequence of plant growth.
Could you let me know what I could place in the script (and where) to make only his sort as described?
The album of his that he wants this to occur in is cat=603
I appreciate it.

[saltyzoo]

This worked for me to do exactly what you describe you want.

Originally Posted by Chuck S

Create some new sort in your sort table like maybe

ORDER BY id ASC

Then just set that to be the default sort in your category editor for that cat

[saltyzoo]

Ah, that will only work for the entire category. You could create a special category for his album.

[Chuck S]

yes adding sorts into the sort table is how you sort cat images

[MediaHound]

For cat 603, sortorder is "1" in my database
Is that what I want to change?
If so, what should I change it to?

[Chuck S]

You change the default sort of a category in Admin => Edit Categories and edit that cats settings

[MediaHound]

Does that #1 coincide with these:
2 Latest ORDER BY disporder,date DESC
3 Most Views ORDER BY disporder,views DESC
1 Most Active ORDER BY disporder,lastpost DESC
4 Most Popular ORDER BY disporder,rating DESC, views DESC
6 Random ORDER BY disporder,RAND()
5 Least Popular ORDER BY disporder,rating,views
7 Image Name ORDER BY disporder,bigimage
8 Title ORDER BY disporder,title

[MediaHound]

Originally Posted by Chuck S

You change the default sort of a category in Admin => Edit Categories and edit that cats settings

It is a user's created album, not a top level category.
It does not appear in Admin -> Edit Categories

[MediaHound]

Originally Posted by MediaHound

Does that #1 coincide with these:
2 Latest ORDER BY disporder,date DESC
3 Most Views ORDER BY disporder,views DESC
1 Most Active ORDER BY disporder,lastpost DESC
4 Most Popular ORDER BY disporder,rating DESC, views DESC
6 Random ORDER BY disporder,RAND()
5 Least Popular ORDER BY disporder,rating,views
7 Image Name ORDER BY disporder,bigimage
8 Title ORDER BY disporder,title

because if it does, I can add a new #9 in there
we could say:
9 Oldest ORDER BY disporder,date ASC

Would that be correct?

[Chuck S]

yes the sorts coincide with those.

Album sorts should be set in Manage Albums in admin just like edit categories is for categories

[MediaHound]

I did not see Manage Albums...
as I retreat with the tail between the legs, may I suggest adding a link to Manage Albums from the bottom of the Category Editor mainframe. Either that or group it with the rest of the Edit quicklinks under "Administration" from "General".
I think it should be easier to find...
anyway I overlooked it and the problem is now solved
thanks!

[MediaHound]

and, oh yes, here is the code I used to add the new field

Content visible to verified customers only.