prev / next news story

Guest

Is there a way to display previous and next story in the news article pages? I see there is a way to show prev / next in the same topic, but I want to display prev / next in overall news stories. Thanks for your help.

Guest

Thanks, but I figured it out myself. Because I had couldn't find anything after googling the heck out of it, here is the code for anyone else trying to do this. I inserted this in my article.php page above the comments section:

$sql ="select sid FROM ".$prefix."_stories where sid < '$sid' order by sid DESC limit 0,1";

$resultprv = sql_query($sql, $dbi);

if (sql_num_rows($resultprv, $dbi)>0) {

list($s_sid) = sql_fetch_row($resultprv, $dbi);

$link_prev = "<a href = \"modules.php?name=News&file=article&sid=$s_sid\">PREVIOUS ENTRY</a> ";

} else

{

$link_prev = "";

}

$sql ="select sid FROM ".$prefix."_stories where sid > '$sid' order by sid ASC limit 0,1";

$resultnext = sql_query($sql, $dbi);

if (sql_num_rows($resultnext, $dbi) > 0) {

list($s_sid) = sql_fetch_row($resultnext, $dbi);

$link_next= "<a href = \"modules.php?name=News&file=article&sid=$s_sid\">NEXT ENTRY</a>";

} else

{

$link_next = "";

}

echo "$link_prev   $link_next\n";