Result sorting

[cdeniz]

i have a code like this

select * from tableX group by fieldA order by fieldB

this code sort according to fieldA. but i need to sort according to fieldB.

please help me ??

[verruckt24]

start a new thread probably this one's already more than 3 years old.

[nav33n]

i have a code like this

select * from tableX group by fieldA order by fieldB

this code sort according to fieldA. but i need to sort according to fieldB.

please help me ??

You should have started a new thread. But anyway, Your query is fine and it should sort on fieldB. Try using ASC or DESC with the query to double check. :)
ie.,

select * from tableX group by fieldA order by fieldB ASC

[cdeniz]

my original code is:

SELECT id_topic, subject 
	FROM smf_messages WHERE  id_board=$bolum 
	GROUP BY id_topic 
	ORDER BY id_msg DESC

it still sort according to GROUP BY.

what are your opunions ??

[nav33n]

It shouldn't. Can you post the table structure as well as some test data ?

[cdeniz]

It shouldn't. Can you post the table structure as well as some test data ?

i am right. :(

thank you for your help..

[almostbob]

once the id topics are grouped the individual id_msgs may not be available for sort
perhaps what you want is

SELECT id_topic, subject FROM smf_messages WHERE  id_board=$bolum ORDER BY id_topic, id_msg DESC