tommyboy123x Posted June 9, 2007 Share Posted June 9, 2007 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 Quote Link to comment Share on other sites More sharing options...
bubblegum.anarchy Posted June 9, 2007 Share Posted June 9, 2007 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 Quote Link to comment Share on other sites More sharing options...
tommyboy123x Posted June 9, 2007 Author Share Posted June 9, 2007 awesome thanks! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.