> > 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.
Here's a function I w
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
On Thu, 13 Sep 2001 14:55, Adrian D'Costa wrote:
> Hi,
>
> I am trying to find out the the best way to do the following:
>
> I have a script that select records from a table. The problem is that
> I need to limit the rows to 20. I know that I can use limit 20. But
> what I want to do is give the
> 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 s
Hi,
I am trying to find out the the best way to do the following:
I have a script that select records from a table. The problem is that I
need to limit the rows to 20. I know that I can use limit 20. But what I
want to do is give the view a link to the next 20 till all the records are
shown.
5 matches
Mail list logo
