MonitorWare Knowledge Base

I hacked on the filter-host.php file to put a drop down box in for existing Hosts/IPs in the database. I can never remember the hostname when I need to. The code is below if anyone else wants to use it. Your DB name may not be the same.

Code: Select all

<?php
        global $global_Con;
        echo '<SELECT name="filhost">';
        echo "<option value=>";
        $sqlstatement = "SELECT distinct(FromHost) FROM SystemEvents;";
        $result = db_exec($global_Con,$sqlstatement);
        while($row = db_fetch_array($result))
        {
                echo "<option value=$row[FromHost]>$row[FromHost]";
        }

        echo '</SELECT>';

#       echo '<input type="text" name="filhost" size="30" value="';
#       echo $_SESSION['filhost'];
#       echo '">';
?>