[Shepski]

I didnt use return (mainly cos i didnt know it existed!) but i did have to reconnect back to the forums database. This code worked when used with XMB.

<?
$i = 0;
$count = 0;

$link2=mysql_pconnect("host", "user", "pass");
mysql_select_db('dbname',$link2);
$query="SELECT n0s_users.id, n0s_users.fname, COUNT(n0s_comments.uid) AS comments
FROM n0s_users INNER JOIN n0s_comments ON (n0s_users.id=n0s_comments.uid)
GROUP BY n0s_users.id ORDER BY comments DESC, n0s_users.fname ASC LIMIT 10";

$result=mysql_query($query) or die(mysql_error());
$numrows=mysql_num_rows($result);

if ($numrows!=0) {
   while($row=mysql_fetch_assoc($result)) {
       $count = $count + 1;
		if ($count==10){
			   echo "<span style=\"font-size: 8pt;\">$count <a href=\"http://users.dvd-swaps.co.uk/user.php?id=$row[id]\" target=_blank>$row[fname]</a></span>";
		} else {
        	   echo "<span style=\"font-size: 8pt;\">$count <a href=\"http://users.dvd-swaps.co.uk/user.php?id=$row[id]\" target=_blank>$row[fname]</a> - </span>";
		}
//        echo "$count <a href=\"http://users.dvd-swaps.co.uk/user.php?id=$row[id]\">$row[fname]</a> - <b>$row[comments]</b>  ";

        }
}
//reconnect to orginal forum database
mysql_pconnect('host', 'username', 'password') or die(mysql_error());
mysql_select_db('dbname') or die(mysql_error());
?>