Sorting problem... session & time

[mancroft]

Sorting problem... session & time

Hello

Lets say you have data like this:

Time Sessionid
20.55 x3
20.44 x3
20.39 a1
20.33 a1
20.29 x3
20.27 x3

and you want to sort it so it looks like this i.e. grouped according to Sessionid and then Time:

x3 = 20.55 20.44 20.29 20.27
a1 = 20.39 20.33

What is the best way to do this in mySQL?

Thank you.

[Wildbug]

It's easy in MySQL 5.0+ (I think that's when it was added) with the much appreciated GROUP_CONCAT() function. Previous to that function, I'm not sure it's possible in MySQL (you'd have to do it in PHP). Try this:

[code]SELECT sessionid,GROUP_CONCAT(time ORDER BY time DESC SEPERATOR ' ') FROM whatever_table GROUP BY sessionid;[/code]

See [a href=\"http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html#id2732618\" target=\"_blank\"]GROUP BY functions[/a] in the manual for more info on options (you can sort the list and specify seperators).

[mancroft]

Thank you, Wildbug.