Postal Codes of
Office Name Delivery Type
State
District
postal code
$num_pages)&&$page!=1)$page= $num_pages;
$limit_start = ($page-1)*$items_per_page;
$sql = "SELECT Circle_Name, Region_Name, DivisionName, OfficeName, Pincode, OfficeType, Delivery, District, StateName, seo_state, seo_dist, seo_office FROM zipcodes WHERE seo_state='$state' AND seo_dist='$dist' ORDER BY Pincode ASC LIMIT $limit_start, $items_per_page";
$items = mysql_query($sql);
echo mysql_error();
if(mysql_num_rows($items)>0)
{
while ($item = mysql_fetch_array($items))
{
if($item[6]=='Delivery')
{
$dlv = "
$item[6]";
}else{
$dlv = "$item[6]";
}
$office = str_replace(" B.O", "", $item[3]);
$office = str_replace(" S.O", "", $office);
$office = str_replace(" H.O", "", $office);
$seoFriendlyURL = generateSeoURL($office);
$res = mysql_query("UPDATE `zipcodes` SET `seo_office` = '$seoFriendlyURL' WHERE `OfficeName` = '$item[3]' AND seo_office=''");
$lnk = "
$item[8]
$item[7]
$item[4]
";
echo "$lnk";
}
}
?>