Help Coding - One Record Per Page

[jemq]

Hi,

I have been trawling the net and this forum for the last two hours for some ideas with regards the following.

I want to be able to display a record per page in the layout of a form.
I then want PREV/NEXT/FIRST/LAST buttons on the bottom of the page to enable movement through the table. If anyone has used NAVICAT, I basically want the FORM VIEW of a table. Either this is too simple and as such is not documented or I am wording my search incorrectly.

Any suggestions or ideas please.

Thanks

Quentin

[leatherback]

What -specifically- do you run into trouble with?

• Select one record
• Display it in a form
• Determine whether you are on the first or the last page
• Create links

..

[jemq]

Sorry,

My main problem is the fact that I do not know how to code the links so that when clicked it moves a record in that direction and then reprints the form with the new details.

[leatherback]

So.. You know how to query the database for a specific record, and you can get the info into the form.

You can create a textlink:

<a href=\"page.php?id=".$id."\">Next page</a>";

// In the page.php you do you not select for the page with $id, but for 
$id=$_GET['id'];
if(is_numeric($id))
  {
  $sql = "select * from table where id > $id limit 1";
  }

Or you can do a similar thing with a form