View file File name : test.php Content :<?php include("../include/config.php"); include("../include/functions.php"); $sql=$obj->query("select distinct(z.city),z.state from tbl_store_zip z where z.status=1 and z.city!='' and z.sectionid like '%3%' group by z.city"); while($result=$obj->fetchNextObject($sql)){ echo htmlentities("<url>"); echo htmlentities("<loc>"); echo SITE_URL_domain."indian-food-delivery/near-me-in-".buildURL($result->city)."-".buildURL($result->state); echo htmlentities("</loc>"); echo htmlentities("<changefreq>"); echo "daily";?><?php echo htmlentities("</changefreq>"); echo htmlentities("<priority>"); ?>0.9<?php echo htmlentities("</priority>"); echo htmlentities("</url>"); echo ""; } ?> <?php $sql=$obj->query("select distinct(z.city),storename,BT_storename,slug,z.state from tbl_store_zip z left join stores s on s.storeid=z.storeid where z.status=1 and s.status=1 and z.city!='' and z.sectionid not like '%3%' group by z.city"); while($result=$obj->fetchNextObject($sql)){ echo htmlentities("<url>"); echo htmlentities("<loc>"); echo SITE_URL_domain."indian-food-delivery/".buildURL($result->city)."-".buildURL($result->state)."/".$result->slug; echo htmlentities("</loc>"); echo htmlentities("<changefreq>"); echo "daily";?><?php echo htmlentities("</changefreq>"); echo htmlentities("<priority>"); ?>0.9<?php echo htmlentities("</priority>"); echo htmlentities("</url>"); echo ""; } ?>