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

Okay....let's say that I Operate fwf.com and have a database called fwfdb and the username is fwfname and the password is fwfpass . My file looks like this:

<?php

mysql_connect($fwf.com, $fwfname, $fwfpass);
mysql_select_db($fwfdb);

$action = mysql_query("SELECT userid, username from user ORDER BY posts DESC LIMIT 1,25") or die("Error: ".mysql_error());

while(list($userid, $username) = mysql_fetch_row($action)){
echo "<a href=\"http://friendswithoutfaces.com/forums/member.php?action=getinfo&userid=$userid\">$userna me</a><br>";
}
?>

Nonono, they should be like this:

mysql_connect(fwf.com, fwfname, fwfpass);
mysql_select_db(fwfdb);

$ denotes a variable.

lol, yeah, don't make variables out of everything

if you don't want to get your head in a knot just add:

$my_user = "fwfname";
$my_pass = "fwfpass";
$dbase = "fwfdb";

above

my_host, $my_user, $my_pass);
mysql_select_db($dbase);

I have been trying to get this one for along time and have been very unsuccesful

If I use this

<?php
// Set this to the max number top posters to display
$num = 25;
$db=mysql_connect(tuffsports.com, username, password);
mysql_select_db(database);
$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\"> °
<A HREF=\"http://tuffsports.com/forum/member.php3?action=getinfo&userid=$latest_array[userid]\">$latest_array[username]</A> ($latest_array[posts])</FONT><BR>";
}

?>

I am getting a parse error with line four

Originally posted by Zecherieh
I have been trying to get this one for along time and have been very unsuccesful

If I use this


<?php
// Set this to the max number top posters to display
$num = 25;
$db=mysql_connect(tuffsports.com, username, password);
mysql_select_db(database);
$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\"> ?
<A HREF=\"http://tuffsports.com/forum/member.php3?action=getinfo&userid=$latest_array[userid]\">$latest_array[username]</A> ($latest_array[posts])</FONT><BR>";
}

?>

I am getting a parse error with line four

Try using quotes, ie:

$db=mysql_connect("tuffsports.com", "username", "password");

Hope that helps

Thanks Guys for your patience! It's working like a charm now!

which of the 5 versions are you using?

ROFL.....errrrrr....I think it may be a new version which is a conglomerate of all of them. <G>

<?php

mysql_connect(mydomain.com, myusername, mypassword);
mysql_select_db(mydatabasename);

$action = mysql_query("SELECT userid, username from user ORDER BY posts DESC LIMIT 1,25") or die("Error: ".mysql_error());

while(list($userid, $username) = mysql_fetch_row($action)){
echo "<a href=\"http://mydomain.com/forums/member.php?action=getinfo&userid=$userid\">$userna me</a><br>";
}
?>

good choise

it seems to be the least 'cluttered'

Originally posted by Susan
ROFL.....errrrrr....I think it may be a new version which is a conglomerate of all of them. <G>

<?php

mysql_connect(mydomain.com, myusername, mypassword);
mysql_select_db(mydatabasename);

$action = mysql_query("SELECT userid, username from user ORDER BY posts DESC LIMIT 1,25") or die("Error: ".mysql_error());

while(list($userid, $username) = mysql_fetch_row($action)){
echo "<a href=\"http://mydomain.com/forums/member.php?action=getinfo&userid=$userid\">$userna me</a><br>";
}
?>

One small change

user ORDER BY posts DESC LIMIT 0,24")

with 1,25 it was starting with the number two poster, 0 brought it to the number one poster