OpenTable();
echo"<table width=\"100%\" border=\"1\">
        <tr bgcolor=\"#FFCCCC\">
          <td width=\"5%\"> <div align=\"center\"><strong>Serial Number</strong></div></td>
          <td width=\"20%\"> <div align=\"center\"><strong>Last Name</strong></div></td>
          <td width=\"20%\"> <div align=\"center\"><strong>First Name</strong></div></td>
          <td width=\"5%\"> <div align=\"center\"><strong>Age</strong></div></td>
          <td width=\"10%\"> <div align=\"center\"><strong>Born In County</strong></div></td>
          <td width=\"20%\"> <div align=\"center\"><strong>Parish</strong></div></td>
          <td width=\"20%\"> <div align=\"center\"><strong>Folio Number</strong></div></td>
        </tr></table><br>";
             
//error message (not found message)
$XX = "<br><br><br><br><center><b>Sorry, No Records Were Found</b></center>";
$query = mysql_query("SELECT * FROM $usertable WHERE $census LIKE '%$search%' LIMIT 0, 30 ");
while ($row  =  mysql_fetch_array($query))
   {
        $variable1=$row["Ser_No"];
        $variable2=$row["Last_Name"];
        $variable3=$row["First_Name"];
        $variable4=$row["Age"];
        $variable5=$row["Born_In_County"];
        $variable6=$row["Parish"];
      $variable7=$row["Folio_Number"];
   

print ("<table width=\"100%\" border=\"1\">
        <tr>
          <td width=\"5%\">$variable1</td>
          <td width=\"20%\">$variable2</td>
          <td width=\"20%\">$variable3</td>
          <td width=\"5%\">$variable4</td>
          <td width=\"10%\">$variable5</td>
          <td width=\"20%\">$variable6</td>
          <td width=\"20%\">$variable7</td>
        </tr>
      </table>");
       
   }

//below this is the function for no record!!
if (!$variable1)   
{
print ("$XX");
}
//end
CloseTable();
include ("footer.php");