You cannot have COUNT(*) without having GROUP BY -- hence, by search query will not produce the desired results -- I'm thinking that there may be something within PHP or MySQL (a Function) that reports the total found for a query whether or not a LIMIT clause is used?
Thanks "Julio Nobrega" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > 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
