PHP DB - LIMIT

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

LIMIT

Dwight Altman

2006-06-29, 6:57 pm

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

Sponsored Links