PHP MySQL ?? ??
ORDER BY ???? ??? ??? ???? ???? ? ?????.
??? ???? ???:
| 關(guān)鍵詞 | 說(shuō)明 |
| asc | 升序排列，從小到大（默認(rèn)） |
| desc | 降序排列，從大到小 |
???
| 類(lèi)別 | 詳細(xì)解釋 |
| 基本語(yǔ)法 | select 字段 from 表 order by 字段 排序關(guān)鍵詞 |
| 示例 | select id,Age from Myguests order by Age desc; |
| 示例說(shuō)明 | 查詢(xún)Myguests表中的id, Age字段，按照降序排序 |
| ????< ?? > | ??? ?? | < / tr>
| ?? ?? | ?? ?? ???? ???? ??? ???? ?? ?? |
| ? | Myguests?? id,Age? ???? ???? ?? desc; |
| ? | Myguests ???? id ? Age ??? ???? ?????? ?? |
SQL? ?? ??? ????? SQL ????? ?????.
?
?? ???? Myguests ???? Age ??? ?????? ?????
<?php
header("Content-type:text/html;charset=utf-8"); //設(shè)置編碼
$servername = "localhost";
$username = "root";
$password = "root";
$dbname = "test";
$con=mysqli_connect($servername, $username, $password, $dbname);
// 檢測(cè)連接
if (mysqli_connect_errno())
{
echo "連接失敗: " . mysqli_connect_error();
}
$result = mysqli_query($con,"SELECT * FROM MyGuests
ORDER BY Age DESC ");
while($row = mysqli_fetch_array($result))
{
echo "id"."---".$row['id']."----". $row['firstname'] . "----" . $row['lastname'] ."----".$row['email']."----".$row['Age'];
echo "<br>";
}
?>???? ?? ??:
?? ?? ??
?? ?? ?????, ???? ?? ?? ???? ?? ??? ??? ??? ??? ? ????.
????
Myguests ???? ???? ?????? ???? 5??
<?php
header("Content-type:text/html;charset=utf-8"); //設(shè)置編碼
$servername = "localhost";
$username = "root";
$password = "root";
$dbname = "test";
$con=mysqli_connect($servername, $username, $password, $dbname);
// 檢測(cè)連接
if (mysqli_connect_errno())
{
echo "連接失敗: " . mysqli_connect_error();
}
$result = mysqli_query($con,"SELECT * FROM MyGuests
ORDER BY Age asc limit 5 ");
while($row = mysqli_fetch_array($result))
{
echo "id"."---".$row['id']."----". $row['firstname'] . "----" . $row['lastname'] ."----".$row['email']."----".$row['Age'];
echo "<br>";
}
?>???? ?? ??? ?????.
SQL? ?? ??? ????? SQL ????? ?????.
