Re: Paging through MySQL results
| From: | Joel Ricker | Date: | Fri, 05 Oct 2001 16:19:32 +0000 |
| Subject: | Re: Paging through MySQL results | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-70108@lists.php.net to get a copy of this message | ||
----- Original Message -----
From: "Andrey Hristov" <ahristov@icygen.com>
> select * from some_table Limit 10,30;
Something to point out, in some of the older versions of MySQL, Offset
starts counting at 0, while in the newer versions, it starts counting at 1.
You'll want to check the documentation for your version.
Joel
> syntaxis
> limit <start>,<offset>
> Andrey Hristov
> IcyGEN Corporation
> Building Solutions
>
> On Friday 05 October 2001 18:52, you wrote:
> > I am a bit new to PHP -- normally use ASP (no booing, please) -- and
trying
> > to find an elegant solution to paging x number of records at a time
through
> > a result set returned to a php page from MySQL.
> >
> > Any ideas?
> >
> > TIA,
> > Bill
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
> For additional commands, e-mail: php-general-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net