Query non valida... aiuto!

[mariox]

Ciao prova così:

$sql = "SELECT consigli_User.UserID,Name,AuthUserID,CommentID,cou nt(*) AS numero_commenti
FROM consigli_User AS u JOIN consigli_Comment AS c JOIN consigli_ThankfulPeople AS v
ON u.UserID=c.AuthUserID
AND c.AuthUserID=v.UserID
AND c.CommentID=v.CommentID
GROUP BY numero_commenti
ORDER BY numero_commenti DESC";

$res=mysql_query($sql) or die ("Query non valida: $sql
Errore: ".mysql_error());

while ($row = mysql_fetch_row($res)) {
echo 'ID: ', $row[0] , ' Nome: ', $row[1] , "\n";