PHP：MySQL Order By 关键词

1、代码

<?php
$servername = "localhost";
$username = "root";
$password = "123456";
$dbname = "mydb";
 
// 创建连接
$con=mysqli_connect($servername,$username,$password,$dbname); 
if (mysqli_connect_errno($con)) 
{ 
    echo "连接 MySQL 失败: " . mysqli_connect_error(); 
} 

$result = mysqli_query($con,"SELECT * FROM myguests ORDER BY firstname");

while($row = mysqli_fetch_array($result))
{
    echo $row['id'];
    echo " " . $row['firstname'];
 
    echo "<br>";
}

mysqli_close($con);
?>

2、表格

3、网页结果