'; echo '

Weapon types

'; $sql = 'SELECT COUNT(*) AS kill_count, weapon_class FROM weapons NATURAL JOIN kills GROUP BY weapon_class ORDER BY kill_count DESC'; $res = mysql_query($sql) or print(mysql_error()); $data = array(); while ($row = mysql_fetch_assoc($res)) { $data[$row['weapon_class'] == '' ? 'other' : $row['weapon_class']] = (int) $row['kill_count']; } echo ' Graph of kills by weapon type

'; echo '

Weapon information

'; echo ''; echo ''; $sql = "SELECT weapon_name, weapon_modifier, weapon_displayname, COUNT(*) as kills, AVG(kill_distance) AS distance FROM weapons NATURAL JOIN kills GROUP BY weapon_displayname ORDER BY kills DESC"; $res = mysql_query($sql); $rank = 1; while ($row = mysql_fetch_assoc($res)) { echo ''; echo ''; } echo '

Rank	Weapon	Modifier	Kills	Avg Distance
', $rank++, '	', htmlspecialchars($row['weapon_displayname']); echo '	', sprintf('%01.1f', $row['weapon_modifier']), '×	', number_format($row['kills']); echo '	', number_format($row['distance']), '

'; echo '