Re: MySql
| From: | Nikunj Virani | Date: | Tue, 08 Apr 2003 11:57:43 +0000 |
| Subject: | Re: MySql | ||
| References: | 1 2 3 4 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-142842@lists.php.net to get a copy of this message | ||
Another one at http://phpbuilder.com/columns/rod20001214.php3.
Hope that helps.
Nikunj Virani
----- Original Message -----
From: "Awlad Hussain" <php@sheridan-phoenix.com>
To: <php-general@lists.php.net>; "Ernest E Vogelsinger"
<ernest@vogelsinger.at>
Cc: "José Pereira" <cdmvirt@cdmvirtual.com>
Sent: Tuesday, April 08, 2003 5:01 PM
Subject: Re: [PHP] MySql
> Good tutorial on << paging >>
> http://www.phpfreaks.com/tutorials/43/0.php
>
> -awlad
>
> ----- Original Message -----
> From: "Ernest E Vogelsinger" <ernest@vogelsinger.at>
> To: <php-general@lists.php.net>
> Cc: "José Pereira" <cdmvirt@cdmvirtual.com>
> Sent: Tuesday, April 08, 2003 12:22 PM
> Subject: Re: [PHP] MySql
>
>
> > At 12:16 08.04.2003, Burhan Khalid said:
> > --------------------[snip]--------------------
> > >On Tue, 2003-04-08 at 04:33, José Pereira wrote:
> > >> How do I create a Next and Previous button for a list from the DB
> > >>
> > >> I have 169 records
> > >> want to limit to about 25 -30 per page and put a search how can
> implament
> > >> this??
> > --------------------[snip]--------------------
> >
> > While RTFM might be a valid option here I assume Jose is a newbie with
PHP
> > and web programming, so here are a few hints:
> >
> > (1) You may consider partitioning your resultset so you can "page"
through
> > it. This can be achieved in 2 possible ways:
> > - retrieve the complete resultset, and only display part of it (using
> array
> > indices)
> > - retrieve only a part of the resultset (using the LIMIT clause)
> >
> > (2) Paging can be done using URL parameters, such as "start" and
> > "count"
> so
> > that the script knows where to start displaying the result, and how many
> > lines to be displayed.
> >
> > I believe you can figure the start out now.
> >
> >
> > --
> > >O Ernest E. Vogelsinger
> > (\) ICQ #13394035
> > ^ http://www.vogelsinger.at/
> >
> >
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>