Re: your ranked out #x of X accounts?
It's not displaying the text.
here is what i use
CREATE TABLE IF NOT EXISTS `accounts` (
`Name` varchar(24) NOT NULL,
`Kills` int(9) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
$lol = mysql_query("SELECT a.Name, a.Kills, CONCAT(You are ranked ,IF(b.Name IS NULL,CONCAT('#',a.rank), CONCAT('joint #',a.rank,' (along with ',COUNT(b.Name),' more)')),' out of ',(SELECT COUNT(*) FROM accounts)) rank FROM ( SELECT $user, Kills, FIND_IN_SET(Kills, (SELECT GROUP_CONCAT(Kills ORDER BY Kills DESC) FROM accounts)) rank FROM accounts) a
LEFT
JOIN accounts b
ON b.Name = a.Kills
AND a.Name <> b.Name
GROUP
BY a.Name
ORDER
BY Kills DESC");
echo "$lol";