Re: [PHP-DB] mysql results with limit

2004-09-04 Thread Michael Gale
Excellent ... thanks that is exactly what I wanted. Michael. On Sat, 04 Sep 2004 20:21:46 -0600 Doug Thompson <[EMAIL PROTECTED]> wrote: > Michael Gale wrote: > > Hello, > > > > Right now I have a mysql select statement with the LIMIT option > > of 500. > > Is there a way to find what

Re: [PHP-DB] mysql results with limit

2004-09-04 Thread Doug Thompson
Michael Gale wrote: Hello, Right now I have a mysql select statement with the LIMIT option of 500. Is there a way to find what the total number of selected results would of been with out doing a mysql select first with out the limi and using mysql_num_rows ? Thanks You could use SQL_CALC_FO