Setting each fetch_array to vars?

[Rifts]

Hello!

 

I'm pretty new to php/mysql so I hope my question makes sense

 

I have this code:

$sql = mysql_query("select * from members ORDER BY 'score' ");

echo "<table border='1'>";
echo "<tr> <th>Name</th> <th>Score</th> </tr>";
while($row = mysql_fetch_array( $sql )) {
echo "<tr><td>"; 
$asd = $row['name'];
echo $row['FacebookID'];
echo "</td><td>"; 
echo $row['score'];
echo "</td></tr>"; 
} 

echo "</table>";

 

and it works just fine it prints out the 3 people in the data base with their score

 

my question is this; is there anyway to set each of the three peoples name to different vars after they are printed?

 

thanks

[trq]

You could store them in an array to use latter.

 

$members = array();
while($row = mysql_fetch_array( $sql )) {
  $members[] = $row;
}

[Rifts]

humm this might be exactly what I need...

 

how would i use them later.

 

for example if I wanted to echo the #3 person

[trq]

echo $member[2]['name'];

[Rifts]

i love you

 

worked perfectly