[請益] 拜託指點一SQL查詢order by 的問題

看板PHP作者s900527 (水)時間17年前 (2007/01/11 18:02)推噓5(5推 0噓 2→)

留言7則, 3人參與討論串1/2 (看更多)

$sql = "select r.id,m.name,count(*),SUM(r.amnt) as ammount FROM member as m , rent as r WHERE r.id = '".$id."' and r.id = m.id group by id order by ammount DESC"; // select c.bookid,c.title,count(*),sum(r.amnt) as ammount from rent as r // here and r.bookid=c.bookid and r.id=m.id group by c.bookid order by ammount desc"; $a = mysql_query($sql); while(list($aid,$name,$count,$sum)=mysql_fetch_row($a)) { echo "<tr>"; echo "<td>$aid</td>"; echo "<td>$name</td>"; echo "<td>$count</td>"; echo "<td>$sum</td>"; echo "</tr>"; $total += $sum; } } 這是我的程式碼想讓他最後按照$sum的大小遞減排序可是卻沒辦法不知道是哪邊出了錯誤拜託各位大大指點一下感激不盡 -- ※ 發信站: 批踢踢實業坊(ptt.cc) ◆ From: 59.117.66.74

推

thitbbeb

01/11 18:13, , 1^F

01/11 18:13, 1^F

推

s900527

01/11 18:46, , 2^F

01/11 18:46, 2^F

推

thitbbeb

01/11 20:36, , 3^F

01/11 20:36, 3^F