How to dynamically overwrite a variable when making a loop in a query?

Question

I have a variable $x = 0 and the $y = 10 in the following query:

select * from tabela limit 10 offset 0

This query makes a loop, more it would need in that loop the value of the offset increase +10 every loop until it reaches the last query line to stop the loop, someone knows how I can be doing this:

My code is like this:

$conexão = mysql_connect('localhost','root','password');
$db = mysql_select_db}('banco');


//essa query é pra fazer o loop da segunda query
$sql = "select * from tabela";
$query = mysql_query($sql);

$rows = mysql_num_rows($query);

while($rows > 0){

   //define o limit
   $x = 0;

   //define o offset
   $y = 4;

  //essa query é que vai retornar a informação
$sql = "select * from limit $y offset $x";

   $query = mysql_query($sql);

while($row = mysql_fetch_array($query){

  resultado da segunda query;
}

}

I would need to do this because I have a table of 5 thousand lines, I need to get all the lines only parceled 100 in 100 lines, the loop only takes from the first line up to the limit that is 10 in the example, what I’m trying to do in this loop: