php升序排列,php 基础问题表单里面怎么升序和降序？

require_once 'conn.php';

//1.查询总记录数

require_Once "DbHelper.class.php";

$arr=array("host"=>"localhost","uid"=>"root","pwd"=>"","dbname"=>"aaa","charset"=>"utf8");

$db=new DbHelper($arr);

$recordcount=$db->getRecordCount("select count(*) from user");

//2.设置每页大小

$perpage=5;

if(isset($_GET['jieshou'])){

$perpage=$_GET['jieshou'];

}

//3.创建分页类对象

require_once "Pager.class.php";

$pager=new Pager(array("total"=>$recordcount,"perpage"=>$perpage));

if (isset($_GET['key'])) {

$key = $_GET['key'];

$sql="select * from user where (uname like '%$key%') or (contacts like '%$key%') or (tele like '%$key%') or

(mobile_phone like '%$key%') or (qq like '%$key%') or (email like '%$key%') or (url like '%$key%') or

(remarks like '%$key%') order by id asc limit $pager->offset,$perpage";

} else{

$sql="select * from user order by id asc limit $pager->offset,$perpage ";

}

$arr=$db->execDql($sql);

echo "

$peopie=array("id"=>"id","uname"=>"uname","contacts"=>"contacts","tele"=>"tele",

"mobile_phone"=>"mobile_phone","qq"=>"qq","email"=>"email","url"=>"url","remarks"=>"remarks");

foreach ( $peopie as $mychars )

sort($peopie);

rsort($peopie);

echo "

id 客户名 联系人 电话 手机 QQ邮箱 地址 备注 ";

foreach ($arr as $row ) {

?>

<?php echo $row['id'];?><?php echo $row['uname'];?><?php echo $row['contacts'];?><?php echo $row['tele'];?><?php echo $row['mobile_phone'];?><?php echo $row['qq'];?><?php echo $row['email'];?><?php echo $row['url'];?><?php echo $row['remarks'];?> &jieshou=<?php echo $perpage;?>"'>删除 修改

}

sort($peopie);

echo "

";

?>

标记地方改怎么改？