PHP4 and MySql - Search Results Question?

From: 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

« previous php.general (#110884) next »