// -------------------------------------------------------------------------------------
// If other skus have been recommended (You have the option to relate other skus with
// this product) display a link to those skus now. This will also happen in the other
// information page and actually show the thumnail images as well (but not here)
// -------------------------------------------------------------------------------------
if ($PROD[OPTION_RECOMMENDSKU] != "") {
$other_skus = split(",", $PROD[OPTION_RECOMMENDSKU]);
$other_skus_count = count($other_skus);
// ----------------------------------------------------------------------------------
// ADD SECURITY CODE [GROUPS] CONTROL OVER SEARCH RESULTS
// ----------------------------------------------------------------------------------
if (isset($GROUPS)) {
$grp_check = " HAVING OPTION_SECURITYCODE IN (";
$grp_tmp = split(";", $GROUPS); // Split this user's sec code groups into individual array
$grp_cnt = count($grp_tmp); // How Many sec groups does this user have access to?
for ($gl=0;$gl<=$grp_cnt;$gl++) { // Start to build SQL "IN" cluster
if ($grp_tmp[$gl] != "") {
$grp_check .= "'$grp_tmp[$gl]', ";
}
}
$grp_check .= "'Public')";
} else {
$grp_check = " HAVING OPTION_SECURITYCODE IN ('Public')";
}
echo "