PHP MySQL Order By

The ORDER BY keyword is used to sort the data in the recordset.

ORDER BY keyword

The ORDER BY keyword is used to sort the data in the recordset.

The ORDER BY keyword sorts records in ascending order by default.

If you want to sort in descending order, use the DESC keyword.

Syntax

SELECT column_name(s)
FROM table_name
ORDER BY column_name(s) ASC|DESC

Example

The following example selects all the data stored in the "Persons" table and sorts the results according to the "Age" column:

<?php
$con=mysqli_connect("localhost","username","password","database");
// 检测连接
if (mysqli_connect_errno())
{
echo "连接失败: " . mysqli_connect_error();
}
$result = mysqli_query($con,"SELECT * FROM Persons ORDER BY age");
while($row = mysqli_fetch_array($result))
{
echo $row['FirstName'];
echo " " . $row['LastName'];
echo " " . $row['Age'];
echo "<br>";
}
mysqli_close($con);
?>

Glenn Quagmire 33
Peter Griffin 35

Sort based on two columns

You can sort based on multiple columns. When sorting by multiple columns, the second column is used only if the first column has the same value:

SELECT column_name(s)
FROM table_name
ORDER BY column1, column2