PHP4 and MySql - Search Results Question?
| From: | Jason Caldwell | Date: | Fri, 02 Aug 2002 20:59:56 +0000 |
| Subject: | PHP4 and MySql - Search Results Question? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-110884@lists.php.net to get a copy of this message | ||
I'm using PHP4 and MySQL --
I'm trying to write a small search engine -- got it working, however, what
I'd like to do is return the TOTAL records found.
You see, right now I am using LIMIT within my SQL -- so I only return 15
results at a time.
How do I get the total (say for example there are 2000 records) -- do I need
to COUNT(*) first, then perform another SELECT query for my search?
Or, is there a PHP/MYSQL command that returns the total records matching my
SELECT query irregardless of the LIMIT ??
Thanks
Jason