Michael Stowe wrote:
How are you using the number?  Probably the easiest way is to utilize 
PDOStatement::FetchAll() and then do a count() on that result set.

There are two things to bear in mind here. Often you are only displaying a subset of records - ten per page perhaps - and so a count of the total helps to populate the navigation tools. COUNT(*) is not the most efficient way of doing that when dealing with large numbers of records, and so keeping a table with a set of counters that are populated via triggers on insert and delete help to speed up that process. FetchAll() should then always produce a full set of records except for the last page ...

Lester Caine - G8HFL
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to