Hi All -
I'm building a search engine and what I would like to do is run a search and
get the number of results, but still use the LIMIT command so I am not
returning a ton of rows all at once.
Is this the best way to go about searching?
Thanks,
Matt Babineau
Criticalcode
w:
I just answered my own question actually!
- snip from php.net -
MySQL 4.0 supports a fabulous new feature that allows you to get the number
of rows that would have been returned if the query did not have a LIMIT
clause. To use it, you need to add SQL_CALC_FOUND_ROWS to the query, e.g.
