php - Divide numbers into equal parts to create Sitemap from mysql

Question

Hi I need something like below

If total number is 2990 , and i want to divide it by 500 equal parts .For example output should be like below stored in array

0,500
500,1000
1000,1500
1500,2000
2000,2500
2500,2990

What I tried

  for($i=0;$i<=2990;$i=$i+500)
    {

if($i%500==0)
{
$var = array_push($var,$i,$+500);
}

   }

P.s : I am creating a sitemap and I need something like this to create LIMIT in my mysql query

Answer 1

Try like

$part_size = 500;
$limit = 2990;

for($i=0;$i<=$limit;$i=$i+$part_size)
{
    $j = $i + $part_size;
    if($j > $limit) {
        $j = $limit;    
    }
    $resultArray[] = $i.','.$j;
}
print_r($resultArray);