RE: LIMIT with mysql_num_rows

2001-07-10 Thread Chris Bolt
He wants to know the maximum, like on a search for mysql at google it says "Results 1 - 10 of about 2,580,000." He wants to know that 2,580,000 number without doing another query. I don't think that's possible. > I'm not sure if I understand your problem. You should get exactly > $end results if

Re: LIMIT with mysql_num_rows

2001-07-10 Thread Werner Stuerenburg
I'm not sure if I understand your problem. You should get exactly $end results if there are more in the result set. Only if you reach the end of your loop, you will get less. Example: You have 48 results and show them in batches of 10. Then you should get 10, 10, 10, 10, 8 results if you show the