LIMIT and total number of rows?

[SFiend]

Hi,
is there any possibility to find out total number of rows when I use LIMIT?

I use PHP and MySql..

Thank you for any idea...

 

[r937]

yes, use the FOUND_ROWS() function

rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (next course starts May 8 2005)

 

[SFiend]

I watched in MySql documentation and PHP documentation and haven't found this function

 

[r937]

http://dev.mysql.com/doc/mysql/en/information-functions.html

rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (next course starts May 8 2005)

 

[SFiend]

Yes, that's it!!!

Thank you, you have saved me a lots of time