$ally1 = mysql_query("SELECT `account` FROM `character` WHERE `race`='1' and `online`!='0'") or die(mysql_error()); $noally1 = mysql_num_rows($ally1); $ally2 = mysql_query("SELECT `account` FROM `character` WHERE `race`='3' and `online`!='0'") or die(mysql_error()); $noally2 = mysql_num_rows($ally2); $ally3 = mysql_query("SELECT `account` FROM `character` WHERE `race`='7' and `online`!='0'") or die(mysql_error()); $noally3 = mysql_num_rows($ally3); $ally4 = mysql_query("SELECT `account` FROM `character` WHERE `race`='4' and `online`!='0'") or die(mysql_error()); $noally4 = mysql_num_rows($ally4); $ally5 = mysql_query("SELECT `account` FROM `character` WHERE `race`='11' and `online`!='0'") or die(mysql_error()); $noally5 = mysql_num_rows($ally5); $noally = ($noally1+$noally2+$noally3+$noally4+$noally5); $horde1 = mysql_query("SELECT `account` FROM `character` WHERE `race`='2' and `online`!='0'") or die(mysql_error()); $nohorde1 = mysql_num_rows($horde1); $horde2 = mysql_query("SELECT `account` FROM `character` WHERE `race`='5' and `online`!='0'") or die(mysql_error()); $nohorde2 = mysql_num_rows($horde2); $horde3 = mysql_query("SELECT `account` FROM `character` WHERE `race`='8' and `online`!='0'") or die(mysql_error()); $nohorde3 = mysql_num_rows($horde3); $horde4 = mysql_query("SELECT `account` FROM `character` WHERE `race`='6' and `online`!='0'") or die(mysql_error()); $nohorde4 = mysql_num_rows($horde4); $horde5 = mysql_query("SELECT `account` FROM `character` WHERE `race`='10' and `online`!='0'") or die(mysql_error()); $nohorde5 = mysql_num_rows($horde5);