RE: [PHP-DB] Next N Interface

2002-09-30 Thread John W. Holmes
> That would actually work for just getting a certain number of records from > a > query, but you would have to execute another query to figure out the > navigational > links he said he wants on the bottom...like google has, << 1 2 3 4 5 >>. > So, > when I attacked it I figured one query is better

Re: [PHP-DB] Next N Interface

2002-09-30 Thread Brad Bonkoski
That would actually work for just getting a certain number of records from a query, but you would have to execute another query to figure out the navigational links he said he wants on the bottom...like google has, << 1 2 3 4 5 >>. So, when I attacked it I figured one query is better then two eve

Re: [PHP-DB] Next N Interface

2002-09-30 Thread Mark Lee
How about appending " LIMIT _GET[startrow],5" to the end of your query. The first parameter to LIMIT is the start position and the second is the number of rows to return. Does this help, or am I misunderstanding your question? Mark Lucas Novæ Matrix wrote: >Hello, > >I am trying to creat

Re: [PHP-DB] Next N Interface

2002-09-30 Thread Brad Bonkoski
I did something like this with a photo gallery I made. The approach I took is the execute a query, get the number of rows, and divide that number by how ever many records I wanted on that page. Then that would give me the number of total pages I would have for my navigational links at the bottom