MySQL sorting question

[safra]

Hi,

I have a form with search criteria for a mysql database. At the bottom I have about 15 checkboxes which can be used to sort the results corresponding the crossed checkboxes.

What is the most efficient way to get the search results from the mysql table in case more then one checkbox is crossed?

Can you do this with one mysql query or do I have to use a different approach?

Thank you,
Ron

[kinadian]

You can sort by more than one column using one query.

SELECT something FROM table WHERE conditions ORDER BY col1, col2, col3;

All you'd need to do is check each checkbox to see if it was checked and build a string (say called $sort) containing each checked option with commas delimiting.

The results of my example query would be sorted first by col1, then col2, then col3.

However, using checkboxes you will not be able to specify which the user would like to sort by first. For this I'd suggest a set of drop down menus, but if you have lots of sort options that could be tedious for you and the user.

--kinadian

[safra]

Thanks Kinadian,

I will try that!

Yes, I realise that it is difficult to allow the user to choose in which order to sort the results and keep the search form easy to use at the same time. I am thinking of improving it in a later stage using something like a timer and some javascript for this but first I want it up and running.

Ron