Creating database navigation using php

Hello

I am creating an application in php which needs to have a Edit portion where user can make changes to different items.

Now in that page I want a navigation

First | Previous | Next | Last

and when user clicks on anyone it should load the data accordingly in the form fields. After that user can change the data and submit it to a script where it is updated accordingly in to a database.

Also I want to have a drop down list on the page where user can select a particular item and it should open the values accordingly in the form fields.

Can anyone give any idea about how to do this or refer to any link where I can find about this?

I honestly don't know how to do this but I have always htought that most have done this with JS not php.

is the data in your database set up with sequential ids?? because you couold just set your link up like

<a href="page.php?id=<?php echo --$_GET['id']; ?>"></a>

then have a select statement in the page wich loads the data like
select * from tablename where fieldid = $_GET['id']

if you see what i mean

jon