RE: PHP + MySQL, how to get total rows matched when using LIMIT 0, 10?

2002-11-05 Thread Jeroen Geusebroek
> 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

Re: PHP + MySQL, how to get total rows matched when using LIMIT 0, 10?

2002-11-05 Thread Joe Stump
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