openside("Najczęściej komentowane!");



$result = dbquery("SELECT tn.*, tu.user_id,user_name ,COUNT(comment_item_id) AS news_comments



              FROM ".$db_prefix."news tn



                LEFT JOIN ".$db_prefix."users tu ON tn.news_name=tu.user_id



              LEFT JOIN ".$db_prefix."comments ON news_id=comment_item_id AND comment_type='N'



              GROUP BY news_id



                ORDER BY news_comments DESC LIMIT 0,5");





               $rows = dbrows($result);



               if ($rows != 0) {



while ($row = mysql_fetch_array($result))



{



echo "<img src='".THEME."images/bullet.gif' alt=''> <a href='".BASEDIR."news.php?readmore=".$row['news_id']."'>".trimlink($row['news_subject'], 15)." (".$row['news_comments'].")</a><br>";



}



}



else {



echo "Brak danych."; }



closeside();