$cmds = array(); $server = @mysql_connect($dbhost , $dbuser, $dbass) or die (mysql_error() . "Verbindung zur Datenbank \"$dhost\" nicht möglich !"); if (!mysql_selectdb($database)) echo mysql_error($server); $sql = "SELECT command FROM admin_commands GROUP BY command ORDER BY command DESC"; $sql = mysql_query($sql,$server); while($acommands = mysql_fetch_assoc($sql)){ array_push($cmds, $acommands); } $smarty->assign("cmds", $cmds); $smarty->display('head.tpl'); $smarty->display('admincmds.tpl'); $smarty->display('footer.tpl'); ?>