Re: [PHP] Re: PHP4 and MySql - Search Results Question?

2002-08-02 Thread Jason Wong
On Saturday 03 August 2002 07:01, Jason Caldwell wrote: > You cannot have COUNT(*) without having GROUP BY -- hence, by search query Not sure what you mean -- SELECT COUNT(*) FROM table; -- works fine. > will not produce the desired results -- I'm thinking that there may be > something within PH

[PHP] Re: PHP4 and MySql - Search Results Question?

2002-08-02 Thread Jason Caldwell
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" <[E

[PHP] Re: PHP4 and MySql - Search Results Question?

2002-08-02 Thread Julio Nobrega
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]">