Re: [PHP] limiting rows and pages like google -- again

2001-09-13 Thread Adrian D'Costa
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,

Re: [PHP] limiting rows and pages like google -- again

2001-09-13 Thread Helen
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 wrote to

[PHP] limiting rows and pages like google -- again

2001-09-12 Thread Adrian D'Costa
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.

Re: [PHP] limiting rows and pages like google -- again

2001-09-12 Thread David Robley
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 view