order by count

[ohdang888]

i want to list out the top video submitters:

each row has u_id in it, and that is their user id. I want to order it by the number of rows that contain the same u_id...

 

How would i do this???

 

my thought:

$vids = mysql_query("SELECT `u_id` FROM `videos` GROUP BY `u_id` ORDER BY COUNT(DISTINCT u_id) DESC LIMIT 10")or die(mysql_error());

[ohdang888]

rump de bump.

thanks.

[MadTechie]

this is mysql problem

 

in anycase.. try

SELECT count(`u_id`) as total, `u_id` FROM `videos` ORDER BY total ASC LIMIT 10;

[gudfry]

 

Maybe your looking for this;

 

$vid=mysql_query("SELECT `u_id` FROM `videos` GROUP BY `u_id` ORDER BY COUNT(DISTINCT u_id) ASC LIMIT 10";