On Tue, 17 Dec 2002, conbud wrote:

> Conbud wrote:
> > Hello,
> > Im using MySQL and PHP 4.2.3 on Apache and Mandrake Linux, I was
> > wondering how to get PHP to list let says row 5 - 10 from a database, I
> > read the MySQL manual and all I could find is LIMIT 0,5 to list just the
> > first 5, but I dont know how to make that list 5 - 10 or 10 - 15. Any
> > help would be appreciated.
> Hey, Is there another way to do it with out using Limit ?

 Sure, select all of the lines, pass a var offset, then loop through the

 for ($i=0;$i<mysql_num_rows($result);$i++) {
    if ($j>=$number_to_display) break;
    if ($i<=$offset) continue;
    print "stuff here";

 Terrible code, I know, but you should be able to get the idea.  Why
 wouldn't you use limit?  That seems silly.

 I know Holmes would agree. :-)

Peter Beckman                                                  Internet Guy
[EMAIL PROTECTED]                             http://www.purplecow.com/

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to