Jump to content

Archived

This topic is now archived and is closed to further replies.

PattyB

Comparing Two Values (Arrays)

Recommended Posts

I am trying to compare the values of two things.

The first set of values comes from a multi-select and outputs like this:  item1,item2,item3,  and etc. for however many options I choose.  I am not sure if this needs to be converted into an array or if it can stay like is?

The second set of values comes from a mysql table.  Say this table contains two fields: email and groups.

What I want to do is compare the first output (item1,etc) to the value of what is in the field groups and have an if statement if there is a match.

For example:  I have a list of users in a table along with their email and groups they belong to.  The user will select the groups they want from a multi-select.  I want to compare the groups selected to the groups each user belongs too and if there is a match to do something.

Im guessing array_intersect can play a role in this but I have been playing for a while and cant get anything to work. 

Any help would be very grateful.

Share this post


Link to post
Share on other sites
I'd use the query to select records only form the groups that the use selected

SELECT * FROM users WHERE group IN ('item1', 'item2'. 'item3')

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.