当我使用SELECT*FROM示例时，我如何将其放在顶部

When Im using SELECT * FROM sample, How Can I Put it on TOP

本文关键字：顶部 SELECT FROM | 更新日期: 2023-09-27

$query = mysql_query("SELECT * FROM sample");
while ($row = mysql_fetch_array($query)){
echo 'Hello, '.$row['name'].'.<br>';
}
Hello, sample.
Hello, sample1.
Hello, sample2.

我希望sample2转到顶部。^

Hello, sample2.
Hello, sample1.
Hello, sample.

$query = "SELECT * FROM sample ORDER BY [field name] ASC/DESC (ascending/descending)";

您可以使用order by子句。。这是的语法

SELECT * FROM sample order by name desc