LIMIT
| From: | Dwight Altman | Date: | Thu, 29 Jun 2006 22:36:40 +0000 |
| Subject: | LIMIT | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-42137@lists.php.net to get a copy of this message | ||
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