Sort data from MySQL table

Question

I have a MySQL table named camp_details which has the following columns :

camp_id, camp_name, location, category, months , pattern

I have input fields which accepts values for location, category, months and pattern.

Based on the details provided, the table should sort according to the preferences (1:location , 2:Months , 3:pattern and 4:category).

That is, the table should display first containing location, next months and so on.

Kindly help me out in this.

What is the question? You can have multiple ORDER BY fields in SQL — Honk der Hase, Jul 29 '16 at 09:20
What have you tried already? What, exactly, are you stuck on? Also, what are you using, mysql or sql-server? — Rich Benner, Jul 29 '16 at 09:20
I'm not sure I 100% understood your question, but here: http://stackoverflow.com/questions/2051162/sql-multiple-column-ordering — Maksim.T, Jul 29 '16 at 09:22

score 0 · Accepted Answer · answered Jul 29 '16 at 09:22

0

just use this query

SELECT * FROM camp_details ORDER BY location , months,patter,category ;

or use DESC after column name which you want to sort in desc like

SELECT * FROM camp_details ORDER BY location , months DESC,patter,category ;

answered Jul 29 '16 at 09:22

Passionate Coder

but location, months, pattern, category will be given by form fields and that how can i pass in order by query ? – Deepa Kamat Jul 29 '16 at 09:37
This query is for display the table value what you exactly want please update your question i just though that you want to display a database table – Passionate Coder Jul 29 '16 at 09:40
Thank You ..Query Working Fine I passed the values in the query – Deepa Kamat Jul 29 '16 at 10:00

1 Answers1