Следующая/Предыдущая



//Предыдущая-следующая
$query = "SELECT DISTINCT n.nid, n.title, n.created
FROM {node} n
INNER JOIN {term_node} tn ON n.nid = tn.nid
WHERE tn.tid = $tid AND n.status = 1
ORDER BY n.sticky DESC, n.created DESC" ;

$result = db_query(db_rewrite_sql($query));

$prev = ''; $next = '';
$before = 0;
while ($anode = db_fetch_object($result)) {
if ( $anode->nid == $node->nid ) $before = 1;

if ( $before == 0 )
$prev = l( $anode->title, "node/$anode->nid" );
else if ( $anode->nid != $node->nid )
{ $next = l( $anode->title, "node/$anode->nid" ); break; }

};