sql output

[Anon]

How can i output data from a count query like this

$result=mysql_query("SELECT user, count(*) as count FROM table GROUP BY c_mom ORDER BY count DESC LIMIT 1")

From this querry i should get a amount and the top user from the count ?? (i hope)

I would like to output the count amount and the user

Lee

[thefury]

$count = mysql_result($result,0);

echo $count;

[thefury]

oops, that would be mysql_result($result,1);
cuz there is something infront of the counter