Location: PHPKode > projects > Network Asset Management Archive > nama/this5.php
<?php
$now = date("m/j/y h:i:s",time());
include "connect.php";
$now = date("j/m/y h:i:s",time());
if ($SERIAL=="") {
$stmt6 = "select * from updates u, arp_table a where (a.IP_ADDRESS = '$REMOTE_ADDR') and (a.serial=u.arp_table)";
} else
{
$stmt7 = "select serial from arp_table where md5='$SERIAL'";
$sth7=ibase_query($dbh, $stmt7);
$row7=ibase_fetch_object($sth7);

$stmt6 = "select * from updates u where (arp_table = '$row7->SERIAL') order by INSTALLED_DATE";
}
$sth6=ibase_query($dbh,$stmt6);
print "</table>";
print '<TABLE BORDER = "1">';
$printheader = 'true';
while ($row5 = ibase_fetch_object($sth6)) {
    if ($printheader=='true')
    {
       print '<th>Installed Date</th><th>Patch Number</th><th>Description</th><th>Release Date</th>';
       $printheader = 'false';
    }
    print "<TR><td>";
    $stmt7 = "select * from updatelist where PATCH = '$row5->PATCH';";
//    echo $stmt7;
    $sth7 = ibase_query($dbh, $stmt7);
    print $row5->INSTALLED_DATE . "</td><td>" . $row5->PATCH ;
    
    if ($row7 = ibase_fetch_object($sth7)) {
        print '</td><td><a href="';
        print $row7->LINK . '" target=window>' . $row7->DESCRIPTION . '</a>';
        print "</td><td>" . substr($row7->RELEASE_DATE,1,10);
    }
    print "</td></tr>";
}
print "</table>";
?>

Return current item: Network Asset Management Archive