I have to say, up until this point I've managed to find answers to all my questions concerning PHP online. However, this is really bugging me.
Basically, I have two fields in MySQL: "skills" and "wants", which a user can submit information into using an array (up to ten fields per array).
I want the users to be matched by cross referencing their "skills" and "wants". So, for example, one user's "wants" may be "English, Portuguese, Spanish" and another user's "skills" may be "Japanese, Portuguese, Turkish". I want the second user to be selected in a MySQL query because one of his "skills" matches with the first user's "wants".
If such a MySQL query did exist, It'd be something like this:
$wants = "English Portuguese Spanish"; //an imploded array
SELECT * FROM users WHERE skills CONTAINS (any piece of information from) '$wants'; //"skills" here is also an array
I am relatively new to PHP, but this has seriously just left my mind = blown.