//鏈接數據庫部分略 $SQL = "SELECT * FROM table ORDER BY pay DESC LIMIT 0,10"; mysql_query($SQL); $List = array(); while ($Result = mysql_fetch_assoc()) { $List[] = $Result;} print_r($List);
select * from tablename order by 字段 desc limit 10;
如果你的数据都放在$arr:foreach($arr as $key=>$list){ $r[$key] = $list['pay']; } array_multisort($r,SORT_DESC,$arr); arrray_slice($arr,0,10);
$result=mysql_query("select * from student order by pay limit 0,10");while($row=mysql_fetch_assoc($result)){ echo $row['pay'];}
原来还不能编辑自己的...刚少打了一段 $result=mysql_query("select * from student order by pay limit 0,10");while($row=mysql_fetch_assoc($result)){ echo "id=".$row['id']."name=".$row['name']."pay=".$row['pay']."<br>";}
//鏈接數據庫部分略
$SQL = "SELECT * FROM table ORDER BY pay DESC LIMIT 0,10";
mysql_query($SQL);
$List = array();
while ($Result = mysql_fetch_assoc())
{
$List[] = $Result;}
print_r($List);
$r[$key] = $list['pay'];
}
array_multisort($r,SORT_DESC,$arr);
arrray_slice($arr,0,10);
echo $row['pay'];}
$result=mysql_query("select * from student order by pay limit 0,10");while($row=mysql_fetch_assoc($result)){
echo "id=".$row['id']."name=".$row['name']."pay=".$row['pay']."<br>";}