//************* for bottom *********************
$year=date("Y");//current year bor bottom
$cty="US";//for gtop - include
//************* end bottom *********************
@ require("incl/db-con.php");
$query="select distinct state_full from zips where 1 order by state_full";
//$result=mysql_query($query) or die(mysql_error());
$result=mysqli_query($db, $query) or die(mysqli_error());
//$nrows=mysql_num_rows($result);
$nrows=mysqli_num_rows($result);
$td1='';
$td2='';
$td3='';
$td4='';
$td5='';
for ($i=0;$i<$nrows; $i++)
{
$row=mysqli_fetch_array($result);
$fstate=stripslashes($row["state_full"]);
$fstate=trim($fstate);
$fslow=strtolower($fstate);
$fslow=str_replace(' ','',$fslow);
$slink='• '.$fstate.' home inspectors';
if($i<13)
$td1=$td1.$slink.'
';
if(13<=$i && $i<26)
$td2=$td2.$slink.'
';
if(26<=$i && $i<39)
$td3=$td3.$slink.'
';
if(39<=$i)
$td4=$td4.$slink.'
';
//----------------------------
}
$sttd='
'.$td1.' |
'.$td2.' |
'.$td3.' |
'.$td4.' |
';
?>
Home Inspections in USA Home Inspectors