$limit_start = 1;
$query = "SELECT * FOM tablename WHERE columnname = 'value' LIMIT $limit_start, 1";
the LIMIT clause takes 2 parameters, the row to start from, above I am using $limit_start for this parament, and the number of rows to return. The LIMIT clause returns a zero indexed array of $rows.
ie if you use LIMIT 2,5, the rows will be returned starting at the 2nd row which fits the SELECT parameters, and reurn 5 rows in an array indexed as 0-4.
By using that variable to designate the start index for the LIMIT clause, you can change it dynamically within a loop.
