Re: LIMIT

What about 'select count(*) from aTable' - Frank > Is there a way to get the number of rows that would have been returned had > there not been a LIMIT clause in a SELECT statement? > > For example, if > Query #1) SELECT * FROM aTable > would normally return 100 rows. But > Query #2) SELECT * FROM aTable LIMIT 5 > will return 5 rows. Is there a way to find out that 100 rows would have > been returned if there was no LIMIT clause, by using only Query #2 and maybe > a PHP function on the $result? > > Regards, > Dwight > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php >