Outputting from a multi select list

Hi Dave, Donna & all;

Thanks for all your great help, I have learned a lot from the forums however, I have searched the forums but was not able to find anything to help with this question.

I am trying to work on getting two lists to output content to a site. The first list - the user can only select one option so I have that one figured out, but the second list they can choose more than one option - can you help me edit the code so that the data is output depending on what checkboxes they have checked.

Here is the code I have so far
list($members_listingRecords, $members_listingMetaData) = getRecords(array(
'tableName' => 'members_listing',
'orderBy' => 'company_name',
'where' => 'category = "lodging"',
'where' => 'sub_category = "cottages"',
));


The first 'where' works well because they can only select one item, but the second 'where' for the sub-category does not display the members listings and I think it is because that is a multi select list and not a single check-box. Is there a way for this to work so they can select multiple sub-categories - like cottages & hotel and then show the same listing both on the Hotel page and the Cottages page?

Thank you for your help, Liz