减小字体
增大字体- ·上一篇文章：PHP MySQL Where 子句
- ·下一篇文章：PHP MySQL Update
PHP MySQL Order By 关键词
PHP MySQL Order By 关键词ORDER BY 关键词用于对记录集中的数据进行排序。ORDER BY 关键词ORDER BY 关键词用于对记录集中的数据进行排序。ORDER BY 关键词默认对记录进行升序排序。如果你想降序排序，请使用 DESC 关键字。语法SELECT column_name(s)FROM table_nameORDER BY column_name(s) ASC|DESC如需学习更多关于 SQL 的知识，请访问我们的 SQL 教程。实例下面的实例选取 "Persons" 表中存储的所有数据，并根据 "Age" 列对结果进行排序：<?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 33Peter Griffin 35根据两列进行排序可以根据多个列进行排序。当按照多个列进行排序时，只有第一列的值相同时才使用第二列：SELECT column_name(s)FROM table_nameORDER BY column1, column2
" . 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 33Peter Griffin 35根据两列进行排序可以根据多个列进行排序。当按照多个列进行排序时，只有第一列的值相同时才使用第二列：SELECT column_name(s)FROM table_nameORDER BY column1, column2
PHP MySQL Order By 关键词
