Is there a way to "accurately" estimate the number of results without using the count rows function? A good example is the google search results page.
Assuming you are talking about mysql and a select statement then why not use the mysql_num_rows function.
I have tried this but it takes far to long with a database that has thousands of records. And yes it is MySQL I am talking about. Does anyone have any suggestions. Thnx