$sql = "";
$page = "other";
include "include.php";
$SQL = "SELECT * FROM printer WHERE printer_id = '" . $_GET['printer'] . "'";
$result = mysql_query($SQL, $db);
if ($myrow = mysql_fetch_array($result)) {
    do {
        echo "<div class=\"main_each\">";
        echo "<table border=\"0\" cellpadding=\"2\" cellspacing=\"0\" width=\"100%\" class=\"content\">";
        echo "<tr><td colspan=\"2\" class=\"contenthead\"><img src=\"images/inv_printer" . $pic_style . ".png\" width=\"64\" height=\"64\" alt=\"\" />&nbsp;" . $myrow["printer_caption"] . "</td></tr>";
        echo "<tr><td>Name:&nbsp;</td><td>" . $myrow["printer_caption"] . "</td></tr>";
        echo "<tr><td>Location:&nbsp;</td><td>" . $myrow["printer_location"] . "</td></tr>";
        if ($myrow["printer_ip"]) {
            echo "<tr><td>Network Address:&nbsp;</td><td>" . ip_trans($myrow["printer_ip"]) . "</td></tr>";
            echo "<tr><td>MAC Address:&nbsp;</td><td>" . return_unknown($myrow["printer_mac_address"]) . "</td></tr>\n";
        } else {
            echo "<tr><td>Attached with PC:&nbsp;</td><td>" . $myrow["printer_system_name"] . "</td></tr>\n";
        }
        echo "<tr><td>Date Discovered:&nbsp;</td><td>" . return_date($myrow["printer_first_timestamp"]) . "</td></tr>\n";
        echo "<tr><td>Manufacturer:&nbsp;</td><td>" . $myrow["printer_manufacturer"] . "</td></tr>\n";
        echo "<tr><td>Model Number:&nbsp;</td><td>" . $myrow["printer_model"] . "</td></tr>\n";
        echo "<tr><td>Serial Number:&nbsp;</td><td>" . $myrow["printer_serial"] . "</td></tr>\n";
        echo "<tr><td>Physical Location:&nbsp;</td><td>" . $myrow["printer_location"] . "</td></tr>\n";
        echo "<tr><td>Date of Purchase:&nbsp;(yyyy-mm-dd)&nbsp;</td><td>" . $myrow["printer_date_purchased"] . "</td></tr>\n";
        echo "<tr><td>Dollar Value:&nbsp;</td><td>\$" . $myrow["printer_value"] . "</td></tr>\n";
        echo "<tr><td valign=\"top\">Description:&nbsp;</td><td>" . $myrow["printer_description"] . "</td></tr>\n";
        echo "<tr><td><form action=\"printer_edit.php?printer=" . $_GET['printer'] . "\" method=\"post\"><input name=\"Submit\" value=\" Edit \" type=\"submit\" class=\"content\" /></form></td></tr>\n";
        $SQL2 = "SELECT * from nmap_other_ports WHERE nmap_other_id = '" . $myrow["printer_mac_address"] . "' ORDER BY nmap_port_number";
        $result2 = mysql_query($SQL2, $db);
        if ($myrow2 = mysql_fetch_array($result2)) {
         } else {
         }
         if ($myrow["video_current_number_colours"] == "16777216") {
             $col_depth = "24 bit";
         } else {
         }
         if ($myrow["video_current_number_colours"] == "4294967296") {
             $col_depth = "32 bit";
         } else {
         }
         echo "<tr><td class=\"contenthead\" colspan=\"2\"><img src=\"images/inv_video{$pic_style}.png\" width=\"64\" height=\"64\" alt=\"\" />Video Adapter #{$opt_count}</td></tr>\n";
         echo "<tr><td>Description:</td><td>" . $myrow["video_caption"] . "</td></tr>\n";
         echo "<tr bgcolor=\"{$bg1}\"><td>Memory:</td><td>" . $myrow["video_adapter_ram"] . " MB</td></tr>\n";
         echo "<tr><td>Current Resolution:</td><td>" . return_unknown($myrow["video_current_horizontal_res"]) . " x " . return_unknown($myrow["video_current_vertical_res"]) . "</td></tr>\n";
         echo "<tr bgcolor=\"{$bg1}\"><td>Current Colour Depth:</td><td>" . return_unknown($col_depth) . "</td></tr>\n";
         echo "<tr><td>Refresh Rate:</td><td>" . return_unknown($myrow["video_current_refresh_rate"]) . "</td></tr>\n";
         echo "<tr bgcolor=\"{$bg1}\"><td>Driver Version:</td><td>" . $myrow["video_driver_version"] . "</td></tr>\n";
         echo "<tr><td>Driver Date:</td><td>" . $myrow["video_driver_date"] . "</td></tr>\n";
     } while ($myrow = mysql_fetch_array($result));
 } else {
     //echo "<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" class=\"content\">";
     //echo "<tr>";
     //echo "<td class=\"contenthead\"><img src=\"images/inv_video$pic_style.png\" width=\"64\" height=\"64\" alt=\"\" />No Video Adapter installed.</td>";
     //echo "</tr>";
     //echo "</table>";
 }
 $SQL = "SELECT * FROM monitor WHERE monitor_uuid = '{$pc}' AND monitor_timestamp = '{$timestamp}'";
 $result = mysql_query($SQL, $db);
 if ($myrow = mysql_fetch_array($result)) {
     do {
         echo "<tr><td class=\"contenthead\" colspan=\"2\"><img src=\"images/inv_monitor{$pic_style}.png\" width=\"64\" height=\"64\" alt=\"\" />Monitor</td></tr>\n";