I have a problem regarding sorting the result of a mysql query. I'll break down the scenario.
Code: Select all
$result = mysql_query("SELECT * FROM users WHERE position_applied LIKE '%$search%' AND age <= $age AND years_exp >= $exp AND status LIKE '%1%'");Code: Select all
while($row=mysql_fetch_array($result))
{
$id = $row['id'];
$position = $row['position_applied'];
$years_exp = $row['years_exp'];
$firstname = $row['firstname'];
$midname = $row['midname'];
$lastname = $row['lastname'];
$age = $row['age'];
$date_membered = $row['date_membered'];
}All this code works fine. My concern is when it outputs those values, I have a drop down box for them to select how to sort based on the names of the columns outputted by the query. How will I do it?