Aceess to Next or previous record

[alirezaok]

hi
i have a table with ID and Title Field. it has some records.
(sort by ID)
ID Title
1 title
5 title
8 title
9 title
11 title
as example the pointer is on ID=8 record:

$query = mysql_query("SELECT * FROM `config` where id=8");
$row = @mysql_fetch_array($query);

is there any way to access the perevious recod or next record? (I don't know what ID number pervious record has when the table is sort by ID)
Thanks

[bpat1434]

Yes, just do:

$query = "SELECT * FROM `config`";
$result = mysql_query($query);

$info = array();
while($row = mysql_fetch_array($result))
{
  $info[] = $row;
}

// Get the 1 previous, and after the ID:
$id = '8';
$max = count($info);
$i = 0;
for($i=0; $i<$max; $i++)
{
  if($info[$i]['id'] == $id)
    $keys = --$i.','.++$i.','.++$i;
}

$keys = explode(",", $keys);

Now, your keys are available in the array: $keys....