I am using $result = mysql_query($query, $dbconnect)
and
while ($row = mysql_fetch_array($result) ) {
to get data out of Mysql. This usually works well, but this time I want to be able to use the current() next() and prev() to step through an array with a next and previous button instead of showing all the records at the same time.
My problem is that I can only retrieve one row at a time, not the entire dataset so I can’t step through it.
Does anybody know how to get a full query into an array that can be stepped through?
Thanks.
