[andyX]

Can anybody help me out with a bit of PHP code that I’m trying to create ?
I want to write a script to pull from a DB a list of results based on a search heading, but only show the fist 20 then provide a link to show the next 20 from the DB then the following 20.
I can count the number of results with the heading that I want to use and pull the first 20, I just can’t find any info on how to pull the next 20 and so on with out repeating the first set of results.
The results from the DB will be updated all the time so giving them an auto increment value will not work either.

I would much appreciate any help, hopefully with a script in PHP that I can transform to do the job.
AndyX

[hardcoded]

SELECT myfields FROM mytables WHERE mysearch LIMIT start,20

However, I'm not 100% sure if the second argument is the end position of the result set ot the size of the result set (I haven't played with SQL for a couple of months now...), but look in the doc for "LIMIT", that's what you're looking for.

[andyX]

Thanks Hardcoded

I will have a look at the Limit. I have seen that before in my admin.

Thanks AndyX

[andyX]

Am I right in thinking, that to get the next 20 I will have another my SQL code block like this !
SELECT myfields FROM mytables WHERE mysearch LIMIT start 20,20;

Is this last bit of code right ?

[hardcoded]

well, you have to remove the "start" keyword. This word is supposed to be replaced by your starting row.

[Orbitz]

Originally Posted by andyX

I can count the number of results with the heading that I want to use and pull the first 20, I just can’t find any info on how to pull the next 20 and so on with out repeating the first set of results.
The results from the DB will be updated all the time so giving them an auto increment value will not work either.
AndyX

You are on the right track.
Google search with this keywords: PHP pagination

You will find plenty of results on what you've been trying to accomplish.
See the sample on my website, the journal sections -

[andyX]

Thanks Hardcoded and Orbitz

I've got it now.
I'll give it a go !

Thanks again AndyX