count database records + limit

[eluser]darkhouse[/eluser]
Good point. I was under the impression that count_all_results() used something like mysql_num_rows() but I actually checked the source, and it just runs a count query. I think that's the smarter way to go.