HELP info site

i want to make a site that shows the top 10 members with the most post , most friends and most pictures so it looks somthing lik this

top 10 members with most post
1 member name
2 member name
3 member name
4 member name
5 member name
.. ect

top 10 members with most friends
1 member name
2 member name
3 member name
4 member name
5 member name
.. ect

then the same for most pictures

but i dont have a clue how to do it

the site the info is coming from is www.connectkent.com

also i want it to updat itself

cheers nicky s

 

You'd need to use the mysql database the site uses, you then perform sql queries in php as follows:

<?
$query = mysql_query("SELECT username FROM members ORDER BY posts DESC");

	while($row = mysql_fetch_row($query ))
	{
?>

<li><?=$row[0]?></li><br />

<?
    }
<?

PHP:

 

any way i can find out the databases with out being able to get on the server ??

 

No, you need the usernames and password to connect to the database.