i want to build html sitemap with 500 link for each sitemap page. my site has more than 10,000 post.
my sitemap.php file
$sql = mysql_query("SELECT * FROM post WHERE id BETWEEN 1 AND 500" );
while($data = mysql_fetch_array($sql))
{
echo "<a href='http://".$data['url']. "'>".$data['title']. "</a>";
echo "<br>";
}
how to get another 500 post via URL parameter?
/sitemap.php?=2 or
/sitemap.php?=501&1000