Displaying one row of table at a time....

[anthony522]

I have a MySQL table that was made from a CSV file (the only thing I added to the table was an auto-increment ID column). I want to display each row of the table one at a time on a formatted page with two buttons/links on the bottom of the page that would allow the user go to the next and previous record. This seemed like something that I would be able to figure out easily but as is always the case I have been struggling with it all day.

Does anybody have any suggestions on how I should go about doing this or can anybody point me to a tutorial that gets into explaining the best way to do this?

Any help would be greatly appreciated.

I didn't put this in the MySQL section b/c I don't think its a SQL problem but if it is, I apologize.

[planetsim]

Simple Pagination

here is fairly simple yet untested example you may need to fiddle around with it

//get pagenumber
$page = (!isset($_GET['page']))? '0' : $_GET['page'];

//query one (Get one row)
$myQuery = mysql_query("SELECT * FROM mytable ORDER BY id DESC LIMIT ".$page.",1");

//query two (get total rows)
$myQueryTwo = mysql_query("SELECT * FROM mytable");

//get result
$row=mysql_fetch_array($myQuery);

/*
  Display Row Information here
*/

//Pagination below
$numRows = mysql_num_rows($myQueryTwo);//total rows

if(($page-1) < $numRows && $page != 0) {
  //display previous
  echo  "<a href\"?page=".($page-1)."\">Previous</a> ";
}

//get Next link
if(($page+1) < $numRows){
   echo  "<a href\"?page=".($page+1)."\">Next</a> ";
}

That should work however like i said its not tested

[anthony522]

Thank you very much.

I also found a tutorial online that was a great help and explained each step of the way. Its from another PHP site but hopefully posting the link won't be a problem (we're all in this together 😃).

Tutorial

Thanks for the help and quick response.