<center>
<center><b><h1>Search Results:</h1></b></center>
<table border="1" cellpadding="5" cellspacing="0" bordercolor="#000000">
<tr>
<td width="60"><center><b>IP</b></center></td>
<td width="60"><center><b>Hostname</b></center></td>
<td width="100"><center><b>FQDN</b></center></td>
<td width="70"><center><b>OS</b></center></td>
<td width="60"><center><b>Up/Down</center></b></td>
<td width="150"><center><b>Location</center></b></td>
<td width="150"><center><b>Last Updated</center></b></td>
</tr>
<tr>
<td>
<?php
$hostname = "localhost";
$username = "dennis";
$password = "sco0tth4snopenis";
$usertable = "table1";
$dbName = "db1";

MYSQL_CONNECT($hostname, $username, $password) OR DIE("DB connection unavailable");
@mysql_select_db( "$dbName") or die( "Unable to select database");
$XX = "No Record Found, to search again please close this window";
$metode = $_REQUEST['metode'];
$search=$_REQUEST['search'];
$count=$_REQUEST['count'];
$sql = "SELECT * FROM $usertable WHERE $metode LIKE '%$search%' LIMIT 0, $count";
$query = mysql_query($sql);
//echo "$sql";

while ($row = @mysql_fetch_array($query))
{
$var1=$row["IP"];
$var2=$row["Hostname"];
$var3=$row["FQDN"];
$var4=$row["OS"];
$var5=$row["UpDown"];
$var6=$row["Location"];
$var7=$row["date"];
print ("<tr>");
print ("<td>$var1</td>");
print ("<td>$var2</td>");
print ("<td>$var3</td>");
print ("<td>$var4</td>");
print ("<td>$var5</td>");
print ("<td>$var6</td>");
print ("<td>$var7</td>");
print ("</tr>");

if ($sql == "")
{
print ("$XX");
 }
}
?>
</table>
</center>