Need MySQL ranking help

[dannon]

Hi I am making a highscores search page for my game, and I don't know how to make a rank

For example I have 2 players in my database

 

Player1 -

xp is 50

attack level is 6

defense levels is 4

 

Player2 - xp is 55

attack level is 4

defense levels is 9

 

And for example i type in player2 it will show the attack level defense level and xp.

 

I need to know how to find out how many tables down the player is?

 

This is my connection thing :

 

$skillsinfo = "SELECT * FROM skills where playerName = '$player'";
$skillsinfo2 = mysql_query($skillsinfo) or die ("Could not connect to players database.");
$skillsinfo3 = mysql_fetch_array($skillsinfo2);

[dannon]

I want know how to make it to print out on my website