08.03.2010, 20:34
|
#6
|
Это просто он
Регистрация: 12.02.2010
Сообщений: 22
Сказал(а) спасибо: 6
Поблагодарили 27 раз(а) в 13 сообщениях
|
Понимаю что не намного лучше но все таки:
PHP код:
mysql_selectdb("$cdb"); $races = array ( 'Humans' => 1, 'Orcs' => 2, 'Dwarves' => 3, 'Night Elves' => 4, 'Undeads' => 5, 'Taurens' => 6, 'Gnomes' => 7, 'Trolls' => 8, 'Blood Elves' => 10, 'Draeneis' => 11 ); $classes = array ( 'Warriors' => 1, 'Paladins' => 2, 'Hunters' => 3, 'Rogues' => 4, 'Priests' => 5, 'Death Knights' => 6, 'Shamans' => 7, 'Mages' => 8, 'Warlocks' => 9, 'Druids' => 11 ); $c_race = array(); $c_class = array(); foreach ($races as $key => $value) { $q = mysql_query ("SELECT COUNT(`guid`) FROM `characters` WHERE `race` = '$value'"); $c_race***91;$key***93; = mysql_result ($q, 0) } foreach ($classes as $key => $value) { $q = mysql_query ("SELECT COUNT(`guid`) FROM `characters` WHERE `class` = '$value'"); $c_class***91;$key***93; = mysql_result ($q, 0) } echo "Races<br>"; foreach ($c_race as $key => $value) echo "$key: $value<br>"; echo "Classes<br>"; foreach ($c_class as $key => $value) echo "$key: $value<br>";
|
|
|