top 10

[pablodelapena]

i have a VERY simple message board on my site, and I want to honer thoses who make a decent contribution.

What I want is a Top10 list. Althoughbeing a newbie I have no idea how to select the top 10 posts counts?

in my table I have a cell with each users post count. What code do I use to select the topn 10 (i.e those with the highest post count)

Would I be along the right lines by suggesting this:

<?php
$query = "SELECT * FROM userinfo ORDER BY postcount DESC, LIMIT 0,10";
$result = mysql_query($query);
?>

[laserlight]

I think it should be:

<?php
$query = "SELECT * FROM userinfo ORDER BY postcount DESC LIMIT 0,10";
$result = mysql_query($query);
?>

[pablodelapena]

would that work yeah?😃😃

yeay!