I've rewritten the race/class count script, now it's both code-efficient and fast, for 0.12 just replace the "$n <= 11" with "$n <= 10" in the second loop and delete the Death Knight row. Enjoy :-)
<?
require_once('config.php');
mysql_connect("$ip", "$user", "$pass");
mysql_select_db ("$mangoscharacters");
$race = array();
$class = array();
for($n=1; $n <= 11; $n++){
$sql = "SELECT COUNT(race) FROM `characters` WHERE `race`=".$n;
$query = mysql_query($sql);
$race[$n] = mysql_result($query, 0);
mysql_free_result($query);
}
for($n=1; $n <= 11; $n++){
$sql = "SELECT COUNT(class) FROM `characters` WHERE `class`=".$n;
$query = mysql_query($sql);
$class[$n] = mysql_result($query, 0);
mysql_free_result($query);
}
echo "Humans: ".$race[1]."
";
echo "Dwarves: ".$race[3]."
";
echo "Night Elf: ".$race[4]."
";
echo "Gnome: ".$race[7]."
";
echo "Draenei: ".$race[11]."
";
echo "Orc: ".$race[2]."
";
echo "Undead: ".$race[5]."
";
echo "Tauren: ".$race[6]."
";
echo "Troll: ".$race[8]."
";
echo "Blood Elf: ".$race[10]."
";
echo "Druid: ".$class[11]."
";
echo "Hunter: ".$class[3]."
";
echo "Mage: ".$class[8]."
";
echo "Paladin: ".$class[2]."
";
echo "Priest: ".$class[5]."
";
echo "Rogue: ".$class[4]."
";
echo "Shaman: ".$class[7]."
";
echo "Warlock: ".$class[9]."
";
echo "Warrior: ".$class[1]."
";
echo "Death Knight: ".$class[6]."
";
?>