<<PREVIOUS 4 5 6 7 8 9 NEXT>> navagati

[Anon]

OK I have an application that pulls data form a table and outputs the results to a catalog style list with <a href> links to see decription of item.

So for example if you choose a category you get a list of descriptions of different items in that category. Of course if the category has 100+ items I dont want to display all 100+ items on the same page.

My question which I am sure is easy is how do I show a limited amount of results per page with the option to see more results with the standard <<Previous 2 3 4 5 6 Next>> style navagation that you would see on a search engine?

I assume that I would create an array of the total records returned and then calculate the results somehow and create variables for <a href> navagation

my table looks like this

repro id (int,primary)<--Identifier for navagation
listing id
field
filed

Any reccomendations would be apreciated, I want the most efficient and best performing code/function

Thanks

[lxghak]

Best way to do it is using a GET variable in the link:

<a href="myscript.php?offset=27">Next</a>

Then use the $offset variable in your sql fetching...

$query = "SELECT * FROM tableName WHERE id > $offset ORDER BY id DESC LIMIT 10";

THat would select the 10 entries after the offset. Then just add 10 to the offset you display, so your next page would be <a href="myscript.php?offset=37">next</a>