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 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 them from
> start to end.
>
> So: I know I have 124 records and issue
>
> SELECT * FROM editions LIMIT 100, 30
>
> I get 24 results.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
