Column title sorting

[lxDestinyxl]

Is it too much to ask to allow the FFR Song List page to sort by 'style'?
http://www.flashflashrevolution.com/...s/FFRSongs.php

It will help immensely.
Thanks.

[Sprite-]

Re: Column title sorting

Done. Sort by date can also be done now.

[[email protected]]

Re: Column title sorting

Could sorting by Author be possible?

[Sprite-]

Re: Column title sorting

author is already sortable...

[[email protected]]

Re: Column title sorting

Oops, my bad xD

[Plan_Bsk81127]

Re: Column title sorting

Might as well add to be sorted by length while you're at it, only on that isnt sortable. lol.

[Sprite-]

Re: Column title sorting

Well it can't sort by length because it's not stored as seconds like it should have been. It wouldn't know how to sort it.

[jimerax]

Re: Column title sorting

Yeah song length is just written as X:XX, and it's just a character string.

If they are written as xxx seconds, it will be sortable.

[I like it]

Re: Column title sorting

Just a question, Why are some songs released on 12-31-69? And why are the old songs all released on 3-3-05? I assume that some songs just messed up, and that their was some sort of update on 3-3-05?

[Sprite-]

Re: Column title sorting

I think the dates weren't stored until 05. Jimerax is going to update all the old dates I believe.

[rushyrulz]

Re: Column title sorting

Yeah song length is just written as X:XX, and it's just a character string.

If they are written as xxx seconds, it will be sortable.

convert to double?.?

[Sprite-]

Re: Column title sorting

mysql won't do that. It can't convert a varchar x:xx to a double