[SOLVED] ORDER BY

[dannybrazil]

Hello

 

I was wondering , can i do this :

 

ORDER BY name AND id ASC ?

 

i want it to be ordered alphabetically and by id (from 1 and up)

 

thanks

[PFMaBiSmAd]

I'm not sure what you are asking, but the answer is probably -

 

ORDER BY name, id

 

Posting an example of what the data is and what the desired output is would help.

[gevans]

Your syntax would need to be as followed;

 

SELECT * FROM `table` ORDER BY `name` ASC, `id` ASC

 

This would order everything by the `name` field. Any identical `name` fields would then be further ordered via their `id` field.

[dannybrazil]

thats it...

 

thanks