//Establish database connection
global $gCms;
$db =& $gCms->GetDb();

//Start Prev-Next
echo('<div class="products_prevnext">');

// Determine previous link
$sql = "SELECT MAX( id ) AS productid FROM cms_module_products WHERE id < " . $params['id'] . ";";
$dbresult =& $db->Execute($sql);
// Print previous links
while ($dbresult && $row = $dbresult->FetchRow())
{     
if($row['productid'] != '') {
  echo '<a href="products/' . $row['productid'] . '/26/">Previous</a>';
}
else {
  echo 'Previous';
}
}

//Determine next link
$sql = "SELECT MIN( id ) AS productid FROM cms_module_products WHERE id > " . $params['id'] . ";";
$dbresult =& $db->Execute($sql);

// Print next links
while ($dbresult && $row = $dbresult->FetchRow())
{     
if($row['productid'] != '') {
  echo '<a href="products/' . $row['productid'] . '/26/">Next</a>';
}
else {
  echo 'Next';
}
}

//End navigation div
echo ('</div>');