SitePoint Sponsor |
|
User Tag List
Results 1 to 6 of 6
Thread: Counting Total Records
Threaded View
-
Jun 5, 2007, 06:58 #1
- Join Date
- Apr 2006
- Location
- Nairobi, Kenya
- Posts
- 93
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Counting Total Records
Hi,
I have a quesry that sometimes retrieves very many records. This made it take a while. So i Introduced LIMIT and Previous and Next links.
This all works quite well.
My problem is that I'd like to know how many records in total will be returned (in all the pages) but i fear that this would be the same us running the query without the LIMIT, which would make it slow again.
How can I overcome this?
AbeLife is too short to think small - John Mason
What is any life if not the pursuit of a dream? - Vanilla Sky
PHP Membership Script
Bookmarks