<?php
echo "xx";
$connection = mysql_connect($host, $user, $password) or die ("Can't connect with $host");
mysql_query('SET NAMES utf8');
mysql_select_db($realmdb, $connection);
$sqle = "SELECT `id`,`banreason`, `bannedby`, `bandate`, `unbandate` FROM `account_banned`";
$sql = "SELECT `ab`.*, `a`.`username` FROM `account_banned` as `ab`"."LEFT JOIN `account` as `a` ON `a`.`id` = `ab`.`id`;";



$result = mysql_query($sql, $connection);
//$result = mysql_query("SELECT * from `таблица`.`столбец` order by `bandate` desc");

while ($vystup = mysql_fetch_array($result))
{
echo "<tr><td align=\"center\">".$vystup["id"]."</td>";
echo "<td align=\"center\">".$vystup["username"]."</td>";
echo "<td align=\"center\">".$vystup["banreason"]."</td>";
echo "<td align=\"center\">".$vystup["bannedby"]."</td>";
echo "<td align=\"center\">".date("d.m.Y H:m",$vystup["bandate"])."</td>";
echo "<td align=\"center\">".date("d.m.Y H:m",$vystup["unbandate"])."</td>";
echo "<td align=\"center\">".актив."</td>";
echo "</tr>";
}
mysql_close($connection);
echo "xx";
?>