The best PHP MySQL Order By Keyword Tutorial In 2024, In this tutorial you can learn ORDER BY Keyword,Sorted according to two,
ORDER BY keyword is used to sort the record set data.
ORDER BY keyword is used to sort the record set data.
ORDER BY keyword default records in ascending order.
If you want to sort in descending order, please use the DESC keyword.
SELECT column_name(s) FROM table_name ORDER BY column_name(s) ASC|DESC
To learn more about SQL knowledge, please visit our SQL tutorial .
The following examples select all data "Persons" stored in the table, and according to "Age" column to sort the results:
<?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); ?>
These results will output:
Glenn Quagmire 33 Peter Griffin 35
You can be sorted according to multiple columns. When sorting by multiple columns, only the first column value when using the same in the second column:
SELECT column_name(s) FROM table_name ORDER BY column1, column2