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?