$resultn = db_query("SELECT nid, title FROM {node} WHERE created > '%d' AND status=1 and promote=1 AND type='%s' ORDER BY created ASC LIMIT 1", $vars['node']->created, $vars['node']->type);
$vars['nextvars'] = db_fetch_object($resultn);
if($vars['nextvars']!= ''){
$vars['next_node'] = l('Next Post »','node/' . $vars['nextvars']->nid, array('html'=>true));
$vars['node']->next_node = $vars['next_node'];
}
$resultp = db_query("SELECT nid, title FROM {node} WHERE created < '%d' AND status=1 and promote=1 AND type='%s' ORDER BY created DESC LIMIT 1", $vars['node']->created, $vars['node']->type);