Re: [nmsinc] Problem with List Options in CMS

Hi,

I think the problem is that your if statement will never reach the "else" block. Since 'isAdmin' must be either true or false, only the first or second block will ever be executed.

What you need is to change the elseif portion of the code. For example, if you had a field called isIndependent and you wanted execute the second block if the current user isn't an admin, but was an independent, you could try this:

<?php if ($CURRENT_USER['isAdmin']):?>
SELECT num, fullname
FROM `<?php echo $TABLE_PREFIX ?>accounts`
WHERE "member_company" = '<?php echo $ESCAPED_FILTER_VALUE ?>num' AND user_type = 'Adjuster'

<?php elseif ($CURRENT_USER['isIndpendent']):?>
SELECT num, fullname
FROM `<?php echo $TABLE_PREFIX ?>accounts`
WHERE <?php echo $CURRENT_USER['member_company_accounts'] ?> = `<?php echo $ESCAPED_FILTER_VALUE ?>member_company_accounts` AND user_type = 'Adjuster'

<?php else: ?>
SELECT num, fullname
FROM `<?php echo $TABLE_PREFIX ?>accounts`
WHERE user_type = 'Adjuster'

<?php endif ?>

The "else" block would then be executed if the current user wasn't an admin or an independent.

Hope this helps get you started.