Pages based on database and navigation buttons

[SmogTheCat]

I've a web site based on php and mysql database.
I create a web page for each record of the database and an "index" page for all records, sorted by country ann name.
You can see records divided by country or by name.

I'd like to add in every web page bottons like "next" and "previous" for visitng pages without come back to the "index" page every time.
How can I do this?

[nottheusual1]

Something along this line would work:

Next record:
SELECT * FROM table WHERE record_id > $current_id ORDER BY record_id LIMIT 1

Previous record:
SELECT * FROM table WHERE record_id < $current_id ORDER BY record_id LIMIT 1

Of course, sub your nomenclature for table, record_id, etc.

We use a product called CodeCharge to do a bunch of our PHP coding. Take a look:

http://www.codecharge.com

Need very few programming skills to create very useable stuff in about 8 languages (PHP, .NET, ASP, etc.)