mysql 查询后重新排序_PHP读取MYsql数据后重新排序问题

$con=mysql_connect("localhost","root","");if(!$con){die('数据库连接失败:'.mysql_error());}else{mysql_query("SETNAMESGB2312");mysql_query("setcharacter_set_client=GB2312")...

$con = mysql_connect("localhost","root","");

if (!$con)

{

die('数据库连接失败: ' . mysql_error());

}

else

{

mysql_query("SET NAMES GB2312");

mysql_query("set character_set_client=GB2312");

mysql_query("set character_set_results=GB2312");

mysql_select_db("db", $con);

$result = mysql_query("SELECT * FROM player_names");

//在表格中输出显示结果

echo "

1	2	3	4	5	6

while($row = mysql_fetch_array($result))

{

echo "

";

echo "

" . $row['unique_id'] . "";

echo "

" . $row['name'] . "";

echo "

" . $row['gold'] . "";

echo "

" . $row['bankgold'] . "";

echo "

" . $row['last_used_time'] . "";

echo "

" . $row['health'] . "";

echo "

";

}

echo "

";

按表格输出后 排序是按照数据库原来的顺序排序的 我想按照bankgold的大小值进行从大到小的降幂排序 希望高人解答 万分感谢

展开