Column title sorting

lxDestinyxl · 12-7-2010, 04:01 AM

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-** · 02-19-2011, 12:48 AM

Done. Sort by date can also be done now.

**duddychuck@yahoo.com** · 02-19-2011, 12:56 AM

Could sorting by Author be possible?

**Sprite-** · 02-19-2011, 12:57 AM

author is already sortable...

**duddychuck@yahoo.com** · 02-19-2011, 12:58 AM

Oops, my bad xD

**Plan_Bsk81127** · 02-19-2011, 01:04 AM

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

**Sprite-** · 02-19-2011, 01:27 AM

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** · 02-19-2011, 01:54 AM

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 · 02-19-2011, 09:40 AM

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-** · 02-19-2011, 10:36 AM

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

**rushyrulz** · 02-19-2011, 11:03 AM

Quote:

Originally Posted by jimerax

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-** · 02-19-2011, 02:36 PM

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

12-7-2010, 04:01 AM	#1
lxDestinyxl FFR Player Join Date: Mar 2006 Posts: 3,247	Column title sorting 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. __________________

02-19-2011, 12:48 AM	#2
Sprite- HAVE ME WITH VODKA Join Date: Aug 2005 Location: Long Island, New York Age: 37 Posts: 7,316	Re: Column title sorting Done. Sort by date can also be done now.

02-19-2011, 12:56 AM	#3
duddychuck@yahoo.com Retired Join Date: Sep 2009 Posts: 1,111	Re: Column title sorting Could sorting by Author be possible? __________________

02-19-2011, 12:57 AM	#4
Sprite- HAVE ME WITH VODKA Join Date: Aug 2005 Location: Long Island, New York Age: 37 Posts: 7,316	Re: Column title sorting author is already sortable...

02-19-2011, 12:58 AM	#5
duddychuck@yahoo.com Retired Join Date: Sep 2009 Posts: 1,111	Re: Column title sorting Oops, my bad xD __________________

02-19-2011, 01:04 AM	#6
Plan_Bsk81127 snooches Join Date: Aug 2007 Age: 34 Posts: 6,420	Re: Column title sorting Might as well add to be sorted by length while you're at it, only on that isnt sortable. lol.

02-19-2011, 01:27 AM	#7
Sprite- HAVE ME WITH VODKA Join Date: Aug 2005 Location: Long Island, New York Age: 37 Posts: 7,316	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.

02-19-2011, 01:54 AM	#8
jimerax ★_★★^★★ Join Date: Nov 2003 Location: Tokyo Posts: 8,185	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.

02-19-2011, 09:40 AM	#9
I like it Housekeeper Join Date: Jan 2007 Posts: 2,122	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?

02-19-2011, 10:36 AM	#10
Sprite- HAVE ME WITH VODKA Join Date: Aug 2005 Location: Long Island, New York Age: 37 Posts: 7,316	Re: Column title sorting I think the dates weren't stored until 05. Jimerax is going to update all the old dates I believe.

02-19-2011, 02:36 PM	#12
Sprite- HAVE ME WITH VODKA Join Date: Aug 2005 Location: Long Island, New York Age: 37 Posts: 7,316	Re: Column title sorting mysql won't do that. It can't convert a varchar x:xx to a double

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)