> I'm trying to get the total matched rows when I'm using "LIMIT 0, 10",
> but I only get the number 10, when the total should be around 100. So,
> can I get total matched rows without doing a separate query using
> count()?
You first have to get the whole result set without the limit OR make use
The mysql_num_rows() function returns the number of rows returned in your
record set, which when limited is 10 (not 100). Thus you will have to do
another query.
--Joe
--
Joe Stump
Affordable Computers, Inc.
800-864-2345 x113
- Original Message -
From: "SED" <[EMAIL PROTECTED]>
To: <[EMAI