PattyB Posted October 30, 2006 Share Posted October 30, 2006 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. Quote Link to comment Share on other sites More sharing options...
Barand Posted October 31, 2006 Share Posted October 31, 2006 I'd use the query to select records only form the groups that the use selectedSELECT * FROM users WHERE group IN ('item1', 'item2'. 'item3') Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.