Best way to sort MySql results based on two columns and show results using pagination?
- by understack
I want to sort results set first based on one column and then based on second column. I know how to do it on server side. And then I want to show these results with pagination feature.
Question: would it be better to do it on client side via ajax in jQuery? I'm using Zend Framework. Would Zend_Paginator module be useful in this scenario?
Basically I want to evaluate all the possible ways? Which one would be best and/or simplest option given I'm using jQuery and Zend Framework?