[jones]

Now I have no installed MySQL 5, so I cannot test it :O(
It's last version. Please, try.

// === Next - Previous products from xCartMod.com ===
$mem_list = func_query("SELECT pr.productid, pr.product FROM $sql_tbl[products_categories] AS cat, $sql_tbl[products] AS pr WHERE cat.categoryid = '$product_info[categoryid]' AND pr.productid = cat.productid AND pr.forsale='Y' ORDER BY pr.product");

$list = array();
if (is_array($mem_list))
foreach($mem_list as $li) {
$mem = func_query_first_cell("SELECT membershipid FROM $sql_tbl[product_memberships] WHERE productid = '$li[productid]'");
if ($mem == $user_account["membershipid"] || $mem == 0 || $mem == "")
$list[] = $li;
}

if (is_array($list))
foreach($list as $x=>$li)
if ($li["productid"] == $productid) {
// previous
if ($list[$x-1]["productid"] != "")
$prev = $list[$x-1];
else
$prev = end($list);

// next
if ($list[$x+1]["productid"] != "")
$next = $list[$x+1];
else
$next = $list[0];
}

$smarty->assign("next", $next);
$smarty->assign("prev", $prev);
// === Next - Previous products from xCartMod.com ====

Alex