SELECT fruit, fiber FROM fruit WHERE color =$color AND calories = $calories AND price = $price LIMIT $offset, $rows code example

Example: mysql limit

SELECT * FROM `members` LIMIT 1, 2;