mysql排序_PHP MySQL Order By 关键词
ORDER BY 关键词
ORDER BY 关键词用于对记录集中的数据进行排序。
语法
SELECT column_name(s)
FROM table_name
ORDER BY column_name
注释：SQL 对大小写不敏感。ORDER BY 与 order by 等效。
例子
下面的例子选取 "Persons" 表中的存储的所有数据，并根据 "Age" 列对结果进行排序：
$con = mysql_connect("localhost","peter","abc123");
if (!$con)
{
die(Could not connect: . mysql_error());
}
mysql_select_db("my_db", $con);
$result = mysql_query("SELECT * FROM Persons ORDER BY age");
while($row = mysql_fetch_array($result))
{
echo $row[FirstName];
echo " " . $row[LastName];
echo " " . $row[Age];
echo " ";
}
mysql_close($con);
?>
以上代码的输出：
Glenn Quagmire 33
Peter Griffin 35
ORDER BY 关键词 ORDER BY 关键词用于对记录集中的数据进行排序。 语法 SELECT column_name(s) FROM table_name ORDER BY column_name 注释：SQL 对大小写不敏感。ORDER BY 与 order by 等效。 例子 下面的例子选取 "Persons" 表中的存储的所有数据，并根据 "Age" 列对结果进行排序： $con = mysql_connect("localhost","peter","abc123"); if (!$con) { die(Could not connect: . mysql_error()); } mysql_select_db("my_db", $con); $result = mysql_query("SELECT * FROM Persons ORDER BY age"); while($row = mysql_fetch_array($result)) { echo $row[FirstName]; echo " " . $row[LastName]; echo " " . $row[Age]; echo " "; } mysql_close($con); ?> 以上代码的输出： Glenn Quagmire 33 Peter Griffin 35