Hi guys,
I have a bunch of stores on a page pulled from store locations table. I want to show only stores that are from region 'Queensland" AND are a store_type of either a "ABC" store or an "other" store.
My viewer code is this:
list($store_locationsqldRecords, $store_locationsqldMetaData) = getRecords(array(
'tableName' => 'store_locations',
'loadUploads' => '0',
'where' => ' region LIKE "%Queensland%" AND store_type LIKE "%ABC%" OR store_type LIKE "%Other%" ',
));
But it keeps showing stores from other states. I presume it is because for some reason it is only paying attention to the second part of the condition I have set. What's wrong with my syntax?
Thanks in advance!