arranging num_rows

[corillo181]

i got this code

but i want to knwo if i can arrage from one to 10 depending on wich one has the most comment.

[code]
<?php
//counting the comments of the picture
$c=mysql_query("SELECT comment_id FROM tra_pcomment WHERE photo_id='".$alphoto['photo_id']."'")or die(mysql_error());
$count=mysql_num_rows($c);
if($count){
echo $count ." comments";
}
?>
[/code]

[fert]

you can with the ASC sql keyword

[corillo181]

yeha i have that in mind but how would put it.. like photo_id asc? thats where i have the problem.

[fert]

[code]
SELECT * FROM `tra_pcomment` WHERE `photo_id`='$photo_id' ORDER BY `num_comments` ASC LIMIT 10
[/code]

[Barand]

This will give the top-ten comment counts for each photo_id, highest count first

[code]
<?php
$c=mysql_query("SELECT photo_id , COUNT(*) as numcomments
                FROM tra_pcomment
                GROUP BY photo_id
                ORDER BY numcomments DESC
                LIMIT 10") or die(mysql_error());

?>
[/code]