php高手来帮忙,mysql怎么用一句代码输出数组数据?
kwdpx 2011-10-28 11:43:44 数据库:member
用户名user 登录次数count 登录时间timeset 序号id
aaaa 22 1310344207 1
bbbb 47 1310344208 2
cccc 33 1310344209 3
现在要输出三组,分别按 登录次数、注册时间、ID排列,普通写法要写三组,这样给数据库是不是读写压力太大了:
//按登录次数
$query="select * from member order by count Limit 0,100";
$result=mysql_query($query,$db);
while ($arr=mysql_fetch_array($result))
{
$count.="$arr[user]";
}
//按注册时间
$query="select * from member order by timeset Limit 0,100";
$result=mysql_query($query,$db);
while ($arr=mysql_fetch_array($result))
{
$timeset.="$arr[user]";
}
//按ID
$query="select * from member order by id Limit 0,100";
$result=mysql_query($query,$db);
while ($arr=mysql_fetch_array($result))
{
$id.="$arr[user]";
}
请问能不能直接一句搞定?
怎么写?比如
$tr_list = array();
$query="select * from member …… in (count,timeset,id) ? Limit 0,10";
$result=mysql_query($query,$db);
while ($arr=mysql_fetch_array($result))
{
$tr_list_index[$arr[' ? ']] .="$arr[user]";
}
具体怎么写,请帮忙,谢谢