Ok Ben, I need the pro's help :lol:

I am trying to display MySQL database record by record/screen by screen (eg, each record takes up one page, when user finished looking at that they press Next Record and page/form gets called again with next record's details).

I am using a form which is calling itself each time:

<form method="post" action="<?php echo $PHP_SELF?>">

and the Next Record button is a normal submit button:

<input type="submit" name="next" value="Next Record">

The problem is that the ID value is not being remembered from the previous form display so I can't get the next record to display - do I need to add the current ID value to the querystring somehow? If so, how do I do that??

I hope that all makes sense!

Ok. So you have a list of records in the database but you want to show one per page right?

To save me having to explain it :cheesygr: , here is a tutorial:

http://www.phpfreaks.com/tutorials/43/0.php

Hope that helps!

__________________
Please read the Forum Rules

Get rewarded for posting - free advertising!
.::. [ Webmaster Resources ] .::. [ Web Design ] .::. [ Developer Tutorials ] .::.

Mr. Tech to the rescue!

Oh and btw Mr. Tech... someone spammed me through PM :?

Thanks Ben you're a legend!! :cheesygr: