Listing database values according to the selected filter in dropdown

Viewed 12960

How do I filter dropdown options to list my table entries?

HTML filter example:

<form action="filter.php" method="post">
  <select name="filter">
    <option>FILTER:</option>
    <option value="alphabetical">ASC</option>
    <option value="date">Date</option>
  </select>
</form>

Basic MySQL select:

SELECT * FROM table ORDER BY name

Basic HTML that lists values:

echo '<h1>'.$name.'</h1>
      <h1>'.$date.'</h1>';

The second filter (date) should do a SELECT that lists all the entries with ASC dates. The second first one (alphabetical) should do a SELECT that lists all the name's entries by ASC only.

Any idea of how the MySQL SELECT would work in that case?

3 Answers
Related