2 Replies Latest reply on Sep 1, 2008 11:12 PM by professorsr

    how to sort php mysql

    professorsr Level 1
      Hello all, I am back. I am working on a site and I want to do a special kind of sort. I have a table with 6 columns.

      I want the user to be able to do a search with the following criteria:

      When the user clicks the column header, I want a drop down box to appear that lists the results of all entries of that field.

      Example:

      Headings are Name, City, Birth Month, favorite color

      when the user clicks City(for example) a list of all of the cities entered appear.
      The user clicks the city that he/she wants and the table is repopulated with only those entries with the selected city in them.