Option Listings with Advanced Filter?

4 posts by 2 authors in: Forums > CMS Builder
Last Post: January 19, 2012   (RSS)

By nmsinc - January 18, 2012

I'm populating a dropdown with files from another field using the advance filter. When using the code below it returns and populates every listing when I only desire those that are labled as "Insurance Dispatcher" or "Dispatcher/Adjuster" - Any suggestions - anyone?

SELECT num, fullname
FROM `<?php echo $TABLE_PREFIX ?>accounts`
WHERE `member_company_accounts` = '<?php echo $ESCAPED_FILTER_VALUE ?>' AND user_type = ('Insurance Dispatcher' || 'Insurance Dispatcher/Adjuster')
nmsinc

Re: [Dave] Option Listings with Advanced Filter?

By nmsinc - January 19, 2012

Hi Dave,

Thanks for the help, it worked perfect. I also have another thread reagaring the code below that has not been answered. I need to populate a dropdown as you can see below using the Advance query; however, I receive a SQL syntax error when I use it.

<select name="company_type">
<option value="Insurance">Insurance</option>
<?php if ($CURRENT_USER['isAdmin']):?>
<option value="Independent">Independent</option>
<?php endif; ?>
</select>
nmsinc

Re: [nmsinc] Option Listings with Advanced Filter?

By Dave - January 19, 2012

Sure, I've posted a question on the other thread and we can continue that conversation there. I'm sure we can figure something out to get it working.
Dave Edis - Senior Developer
interactivetools.com