Re: limiting rows and pages like google -- again
| From: | Adrian D'Costa | Date: | Thu, 13 Sep 2001 10:38:46 +0000 |
| Subject: | Re: limiting rows and pages like google -- again | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-67178@lists.php.net to get a copy of this message | ||
On Thu, 13 Sep 2001, Helen wrote:
> > The logic would be to check if the script is called the first time, then
> > the sql statement would be select travel.*, city.city from travel, city
> > where travel.cityid=city.id limit 0,20.
> > The second time or based on what has been selected on the page (1-20,
> > 21-40, etc) add that to the sql statement. My question is how
>
> Do you want to list all the pages of posts or just a link to the next 20
> items?
On the first page, 20 and links to the other items that when selected will
display the list based on the selection.
One thing to remember is that the ids will not be in squence.
Thanks
Adrian