Код:
$race_1 = mysql_query('SELECT * FROM `characters` WHERE `race` = "1"');
$row_race_1 = mysql_num_rows($race_1);//Alliance
$race_2 = mysql_query('SELECT * FROM `characters` WHERE `race` = "2"');
$row_race_2 = mysql_num_rows($race_2);//Horde
$race_3 = mysql_query('SELECT * FROM `characters` WHERE `race` = "3"');
$row_race_3 = mysql_num_rows($race_3);//Alliance
$race_4 = mysql_query('SELECT * FROM `characters` WHERE `race` = "4"');
$row_race_4 = mysql_num_rows($race_4);//Alliance
$race_5 = mysql_query('SELECT * FROM `characters` WHERE `race` = "5"');
$row_race_5 = mysql_num_rows($race_5);//Horde
$race_6 = mysql_query('SELECT * FROM `characters` WHERE `race` = "6"');
$row_race_6 = mysql_num_rows($race_6);//Horde
$race_7 = mysql_query('SELECT * FROM `characters` WHERE `race` = "7"');
$row_race_7 = mysql_num_rows($race_7);//Alliance
$race_8 = mysql_query('SELECT * FROM `characters` WHERE `race` = "8"');
$row_race_8 = mysql_num_rows($race_8);//Horde
$race_10 = mysql_query('SELECT * FROM `characters` WHERE `race` = "10"');
$row_race_10 = mysql_num_rows($race_10);//Horde
$race_11 = mysql_query('SELECT * FROM `characters` WHERE `race` = "11"');
$row_race_11 = mysql_num_rows($race_11);//Alliance
$char = mysql_query('SELECT * FROM `characters`');
$char_all = mysql_num_rows($char);
//All Guide
$guild = mysql_query('SELECT * FROM `guild`');
$guild_all = mysql_num_rows($guild);
//All Char in guide
$guild_member = mysql_query('SELECT * FROM `guild_member`');
$guild_member_all = mysql_num_rows($guild_member);
//All NPC
mysql_select_db($m_db, $cont);
$npc = mysql_query('SELECT * FROM `npc_vendor`');
$npc_all = mysql_num_rows($npc);
//All Item
$item = mysql_query('SELECT * FROM `item_template`');
$item_all = mysql_num_rows($item);
//All Gameobject
$gameobject = mysql_query('SELECT * FROM `gameobject_template`');
$gameobject_all = mysql_num_rows($gameobject);
//All Quest
$quest = mysql_query('SELECT * FROM `quest_template`');
$quest_all = mysql_num_rows($quest);
руки бы тебе оторвать за оптимизированные запросы...
http://www.mysql.ru/docs/man/Counting_rows.html читать до понимания