ho corretto la query in questo modo:
ma nada...Codice PHP:
$qqq = mysql_query("
SELECT ns.*, COUNT(c_nid) AS num
FROM news AS ns, commenti
WHERE ns.n_id = commenti.c_nid
GROUP BY n_id DESC LIMIT 0, ".$conf['num_news'])
or die(mysql_error());
while ($news = mysql_fetch_array($qqq)){
echo '<p class="item_top">'.$news['n_title'].'</p>';
echo $news['n_text'];
echo '<div align="right">Leggi Commenti ('.$news['num'].')</div>';
}
![]()