Jump to next or previous row

[djmystic82]

I'm trying to find a script to jump to the next or previous row in a database table. It's easy to select from a column name, but how do I jump to the next row?

[liquorvicar]

mysql_fetch_row/array/assoc will automatically get the next result row from your query.

if you need to flick back and forth quite a bit, you may want to read the whole query into an array and use the array functions to traverse the array.

[djmystic82]

Gave that a try. Bit new at this so not quite sure whether I'm going about it the right way or not.

This is how I select the data at the moment:

$sql = "SELECT id, title, description, image FROM $table_name ORDER by id";
$result = @($sql,$connection) or die("Couldn't execute query.");
while ($row = mysql_fetch_array($result)) {
$id = $row['id'];
$title = $row['title'];
$description = $row['description'];
$image = $row['image'];

How would you add the "mysql_fetch_row/array/assoc" into this?

[Sxooter]

Definitely look in the code snippet libray on this very site for some examples of how to do this.