$ban_acc=("select count(access_level) as ban from $login_db.accounts where access_level<0 "); $result =mysql_query($ban_acc); $row = mysql_fetch_array($result); $acc_ban=($row['ban']); if ($acc_ban==0) $acc_ban="none"; echo "Banned accounts: $acc_ban "; $ban_accs="select login from accounts where access_level<0"; $result =mysql_query($ban_accs); while ($row = mysql_fetch_array($result)){ $accs_ban=($row['login']); echo " $accs_ban, "; } echo "
"; $ban_chars = "SELECT count(accesslevel) AS nonban FROM characters WHERE accesslevel > 0"; $result = mysql_query($nonban_chars); $row = mysql_fetch_array($result); $nonban_chars = $row['nonban']; //$ban_chars = ($row['ban']); If ($ban_chars==0) $ban_chars="none"; echo"Banned characters: $ban_chars
";