PHP Ranking System, how do I go about doing this?

[arcanisjk]

I'm on a school assignment and I've ran into some trouble and is in need of some urgent help.

Table name: users

ID  |  username  |  score
1   |  member A  |  100
2   |  member B  |  200
3   |  member C  |  300
4   |  member D  |  0

I want show the top 3 members by their score in descending order in PHP.

My sql query for this would be

SELECT username, score FROM users ORDER BY score DESC LIMIT 0,3

I'd like it to be in a simple format like below

Rank: 1 / User: member C / Score: 300
Rank: 2 / User: member B / Score: 200
Rank: 3 / User: member A / Score: 100

I've gotten this much so far, could anyone help me with the PHP part and how to echo it out?

[Dormilich]

check out mysql_query(), this should get you started.

[Markus]

How is the data stored? MySQL? MSSQL? Flat-file?

[arcanisjk]

It's stored inside MySQL. But I've got it figured out already.

<?php

//mysql connection stuff

$query1=mysql_query("SELECT * FROM users ORDER BY score DESC LIMIT 0,5");
			echo "<table border='0'>
			<tr>
			<td><b><div align='left'></div>User</b></td><td>&nbsp;</td>
			<td><b>Score</b></td>
			</tr>";
			
			while($row = mysql_fetch_array($query1))
			  {
			  echo "<tr>";
			  echo "<td><div align=left>" . $row['username'] . "</div></td><td>&nbsp;</td>";
			  echo "<td><div align=center>" . $row['score'] . "</div></td>";
			  echo "</tr>";
			  }
			echo "</table>&nbsp;&nbsp;";
	

?>