Location: PHPKode > projects > Tcpdb > tcpdb/tcpip.php
<html>
<head>
<body>
<base target="main">
<?php
require 'config.php';

 $sql = mysql_query("SELECT * FROM subnet where subnet_id like '$subnet_id'");

    while ($res = mysql_fetch_array($sql)) {
		$subnet_name = $res["subnet_name"];
		$location = $res["location"];
		
		
echo "<font face='verdana' color='#00066' size=5><strong>$location - $subnet_name</strong>";
}
?>
<hr>
<table border="0" cellpadding="0" cellspacing="0" summary="">
<tr>
<td><font face='verdana' color='#00066' size=2><b>TCP/IP&nbsp;</td>
<td><font face='verdana' color='#00066' size=2><b>Hostname&nbsp;</td>
<td><font face='verdana' color='#00066' size=2><b>OS&nbsp;</td>
<td><font face='verdana' color='#00066' size=2><b>Machine Type&nbsp;</td>
<td><font face='verdana' color='#00066' size=2><b>Description&nbsp;</td>
</tr>

<?php

 $sql = mysql_query("SELECT * FROM tcpip where subnet_id like '$subnet_id' ORDER BY sort");

    while ($res = mysql_fetch_array($sql)) {
		$tcpip_id = $res["tcpip_id"];
		$tcpip = $res["tcpip"];
		$hostname = $res["hostname"];
		$os = $res["os"];
		$machine_type = $res["machine_type"];
		$description = $res["description"];
	     
	  print "<tr>\n";
		print "<td><a href=\"edit_tcpip.php?tcpip_id=$tcpip_id&tcpip=$tcpip&hostname=$hostname&os=$os&machine_type=$machine_type&subnet_id=$subnet_id&description=$description\"><font face='verdana' color='#00066' size=2>$tcpip</a>&nbsp;</td>";
		print "<td><a href=\"edit_tcpip.php?tcpip_id=$tcpip_id&tcpip=$tcpip&hostname=$hostname&os=$os&machine_type=$machine_type&subnet_id=$subnet_id&description=$description\"><font face='verdana' color='#00066' size=2>$hostname</a>&nbsp;</td>";
		print "<td><a href=\"edit_tcpip.php?tcpip_id=$tcpip_id&tcpip=$tcpip&hostname=$hostname&os=$os&machine_type=$machine_type&subnet_id=$subnet_id&description=$description\"><font face='verdana' color='#00066' size=2>$os</a>&nbsp;</td>";
		print "<td><a href=\"edit_tcpip.php?tcpip_id=$tcpip_id&tcpip=$tcpip&hostname=$hostname&os=$os&machine_type=$machine_type&subnet_id=$subnet_id&description=$description\"><font face='verdana' color='#00066' size=2>$machine_type</a>&nbsp;</td>";
		print "<td><a href=\"edit_tcpip.php?tcpip_id=$tcpip_id&tcpip=$tcpip&hostname=$hostname&os=$os&machine_type=$machine_type&subnet_id=$subnet_id&description=$description\"><font face='verdana' color='#00066' size=2>$description</a>&nbsp;</td>";
    print "</tr>\n\n";
		
    }
?>
</table>
Return current item: Tcpdb