<center>
<table border="1" cellpadding="5" cellspacing="0" bordercolor="#000000">
<tr>
<td width="60"><b>IP</b></td>
<td width="100"><b>FQDN</b></td>
<td width="70"><b>OS</b></td>
<td width="150"><b>UpDown</b></td>
<td width="150"><b>Location</b></td>
</tr>
<tr>
<td>
<?php
 $hostname = "localhost";
$username = "dennis";
$password = "q1w2e3r4";
$usertable = "chwt1";
$dbName = "chwdb";

MYSQL_CONNECT($hostname, $username, $password) OR DIE("DB connection unavailable");
@mysql_select_db( "$dbName") or die( "Unable to select database");
//error message (not found message)begins
$XX = "No Record Found, to search again please close this window";
//query details table begins
$sql = "SELECT * FROM details WHERE $metode LIKE '%$search%' LIMIT 0, 50;";
$query = mysql_query($sql);
echo "$sql";
while ($row = @mysql_fetch_array($query))
{
$variable1=$row["IP"];
$variable2=$row["FQDN"];
$variable3=$row["OS"];
$variable4=$row["UpDown"];
$variable5=$row["Location"];

//table layout for results

print ("<tr>");
print ("<td>$variable1</td>");
print ("<td>$variable2</td>");
print ("<td>$variable3</td>");
print ("<td>$variable4</td>");
print ("<td>$variable5</td>");
print ("</tr>");
}
//below this is the function for no record!!
if (!$variable1)
{
print ("$XX");
}
//end
?>
</table>
</center>