Pulling out top friends

[textbox]

Hello.

I wish to pull out a row of the top 3 friends.

 

The top friends bit i think i can sort, however, which is the best way to retrieve the image and username and link the username into the picture?

 

	$getimages = mysql_query("SELECT `username`, `thumblocation` FROM `images` WHERE 
							`timeposted` ORDER BY `timeposted` ASC LIMIT 3");
while 
($image=mysql_fetch_array
	($getimages)
)
{
echo "<a href='/__site/$username'><img src=\"$image[thumblocation]\"></a>";echo $spacer;

}

 

I have this, but it doesnt appear to help me much!

Thanks in advance

[phast1]

Try it like this:

 

$getimages = mysql_query("SELECT username, thumblocation FROM images ORDER BY timeposted ASC LIMIT 3");
while  ($image=mysql_fetch_assoc($getimages)) {
  echo "<a href='/__site/$username'><img src=\"$image['thumblocation']\"></a>";
  echo $spacer;
}