Select ข้อมูลในตารางเดียวกัน เพื่อนับจำนวน ข้อมูลดูให้หน่อยคับ

$sql = mysql_query("select count(MSG_PID),MSG_SUBJECT from Mytable GROUP BY MSG_PID");

$sql = mysql_query("select count(MSG_PID) AS BP ,MSG_SUBJECT from Mytable GROUP BY MSG_PID") ORDERBY BP DESC;

SELECT MSG_ID,
       MSG_PID,
       count(MSG_PID) AS BP,
       MSG_SUBJECT
  FROM messages
 WHERE BOARD_ID = 'BID001'
GROUP BY MSG_ID
ORDER BY MSG_PID ASC, MSG_ID DESC