2 Replies Latest reply on Apr 28, 2010 8:52 PM by elgol

    Simple sort list by field?

    elgol

      I'm a noob and can't figure out an easy way to sort a list of licensees (http://motionevolution.com/subscribe.html, "Current Licensees" tab) by state. The list changes weekly, and I have it in a mySQL database but have not figured out how to get this done. Any suggestions most appreciated.

       

      Elgol

        • 1. Re: Simple sort list by field?
          bregent Most Valuable Participant

          You'll can put it into a table and then allow the user to click on the table heading to change the sort order. You can do this either by sending the new order by clause in the SQL and requerying the database, or sort with the DOM. I prefer the DOM as it is much faster when dealing with small volumes of data. Looking at your current data everything is just comma seperated. It is not obvious if you have it stored in more than one column, but you will need to do that.

          • 2. Re: Simple sort list by field?
            elgol Level 1

            Thanks very much! The DOM thing did the trick and the client loves it. I sincerely appreciate the help.

             

            Elgol