<?php

$host = "localhost";
$user = "username";
$pass = "passwort";
$db = "datenbankname";

mysql_connect($host, $user, $pass);
mysql_select_db($db);
unset($host,$user,$pass,$db);

$result = mysql_query("SELECT users_xfire FROM cms_users where users_xfire != ''");


echo "<table>";

while ($row = mysql_fetch_array($result))
{ echo "<tr><td><a href=http://www.xfire.com/profile/$row[0]>$row[0]</a><a href=http://www.xfire.com/profile/$row[0]><img src='http://miniprofile.xfire.com/bg/bg/type/4/$row[0].gif'></td><td >$row[1]</td><td>$row[2]</td><td>$row[3]</td>"; }

echo "</table>";
?>

"; while ($row = mysql_fetch_array($result)) { echo "$row[0]$row[1]$row[2]$row[3]"; }echo ""; ?>