[SOLVED] mysql secondary "order by"?

[tommyboy123x]

is there a way to order a second field in mysql?

 

lets say the database looks like this:

Topic---------------Name

Javascript----------page1

Javascript----------my_hate_for_it

Javascript----------only_some_support_it

PHP----------------its_way_better

PHP----------------page1

PHP----------------isnt_it_great?

....etc

 

i know this doesn't work, but something similar to this...

 

SELECT * FROM search1 ORDER BY Topic AND Name ASC

 

how Topic will be in alphabetical order (ex: Javascript, PHP), and for each topic, file will be in alphabetical order (ex: my_hate_for_it, only_some_support_it, page1).

 

 

 

I know you could just grab the first topic, then order by the file WHERE topic='$topic', but just seeing if someone knows of an easier / less annoying way

[bubblegum.anarchy]

Replace the AND with a comma, sort order direction can also be applied to each sorted column such as:

 

SELECT * FROM search ORDER BY topic DESC, name ASC 

[tommyboy123x]

awesome thanks!