You would have to do first a:
SELECT COUNT(*) FROM mytable WHERE foo=bar;
to get the number of records. If they are over 10, in this example, do a:
SELECT * FROM mytable WHERE foo=bar LIMIT $start,10
$start is the offset and should be 0 when you want the 10 first results.
Then it's just up to you to do the rest of the coding. There are examples of this in the 'Article' section of this site.
(And please.. drop the 'r' for are.. It's not cool)
