I need to get the previous and next ID's from a table. The table has a group that they are in as well. I have the following code, but it will only pull the ID of the current page.


$sqlnext = mysql_query ("SELECT * FROM tutorials WHERE id > '$id' AND series='$series' ORDER BY id LIMIT 1");
$rownext = mysql_fetch_array ($sqlnext);
$nextid = $row['id'];
$nextname = $row['name'];
if((!empty($nextid)) && ($nextid != $id))
{
$next="<a href=\"./$basepage?page=tutorials&command=view&id=$nextid\">$nextname</a>";
}


I can offer more code if needed.

$nextid = $row['id']+1;

Try that?

No, because it won't work the way I need it to.

The table will have multiple groups or series. SO id+1 is likely to be in a different series, or hidden.

I found what was wrong... just a typo. I forgot to change it to $nextid = $rownext['id']; causing it to use the prior query instead.