Top 25 Posters

We are working on trying to use the include for top 25 posters on our index.php page...and we keep getting an error. We managed to put the latest 12 posts on the index.php page but adding the top posters isn't working.

COuld someone post the perfect :lol: script here with simple instructions for me to follow?

I would sure appreciate it!

Thanks!
Kathy

Actually, LIMIT 0,25. Or, even better, LIMIT 25. The first number is the beginning (remember, computers start with 0), and the second is how many to get. Thats why it's LIMIT 25,5, not LIMIT 25,30.

Get it? Got it? Good.

I just got this one to work perfectly for me, finally

I was missing that little bit of knowledge Menno threw in about putting " " around the database name and such

<?php
// Set this to the max number top posters to display
$num = 25;
$rank = 1;

$db=mysql_connect("localhost","YOURDATABASEUSERNAM E","YOURDATABASEPASSWORD");
mysql_select_db("YOURDATABASENAME");
$query = "SELECT * FROM user ORDER BY posts DESC LIMIT $num";
$resultlatest = mysql_query($query,$db);
while ($latest_array = mysql_fetch_array($resultlatest)) {
echo "<FONT SIZE=\"1\" FACE=\"Verdana, Arial, Helvetica, sans-serif\"> $rank
<A HREF=\"http://yourdomain/forums/member.php?action=getinfo&userid=$latest_array[userid]\">$latest_array[username]</A> ($latest_array[posts])</FONT><BR>";
$rank = ($rank+1);
}

?>

Made one little change so it will show the number rank instead of just the little character

heh...we noticed tonight that the number one person was missing....and since there seems to be a bit of a contest to see who can be the top poster, this was really funny to me. She tried so hard to be number 1 and then wasn't shown in the top posters at all. LOLOLOLOL Okay...fixing it.

whoops, ever so sorry about the 1,25 thing
it's been hectic, so my coding has been shit lately

Originally posted by Menno
whoops, ever so sorry about the 1,25 thing
it's been hectic, so my coding has been shit lately

No reason to apoligize, a little oversite by you can make the rest of us learn a lot. Figuring out little tiny details is just the first step of building a knowledge to acutally be able to program in - hell I was pumped when I figured it enough to make it count and put out the right rank number.

So I take pleasue in the simple things, but since I have not coded in over ten years and never heard of php until about two months ago I am happy.