$res=mysql_query("select * from table group by kind"); while($arry=mysql_fetch_array($res)) { $kind=$arry["kind"]; $result=mysql_fetch("select * from table order by time where kind='$kind'"); while($array=mysql_fetch_array($result)) echo $array["name"]; echo "<br>"; }一行一类以时间排序
order by time desc,kind
记住一定要先分类,再排序 所以: group by 类别 order by 时间
记住一定要先分类,再排序 所以: group by 类别 order by 时间 没错.就是这样.
用 group by 會造成相同類別的資料只顯示1筆. 應該先排類別,再排時間 order by kind,time
while($arry=mysql_fetch_array($res))
{
$kind=$arry["kind"];
$result=mysql_fetch("select * from table order by time where kind='$kind'");
while($array=mysql_fetch_array($result))
echo $array["name"];
echo "<br>";
}一行一类以时间排序
所以: group by 类别 order by 时间
所以: group by 类别 order by 时间
没错.就是这样.
應該先排類別,再排時間 order by kind,time