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

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 create a

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 even

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 then two