You could select everything, count the results, and just show 15 results.
I am not sure that a COUNT() with LIMIT will perform the desired effect. -- Julio Nobrega Pode acessar: http://www.inerciasensorial.com.br "Jason Caldwell" <[EMAIL PROTECTED]> escreveu na mensagem [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > 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 > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
