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. Link to comment https://forums.phpfreaks.com/topic/25636-comparing-two-values-arrays/ 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') Link to comment https://forums.phpfreaks.com/topic/25636-comparing-two-values-arrays/#findComment-117089 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.