so I am new to PHP and developing a project that should put students in a classroom into groups of 3 students each and assign advisors to each group based on the specialties of each advisor.
the students are required to submit titles with keywords and the advisors are registered with specialties as keywords.
the students title table structure is like below
table titles{
groupName varchar(),
title varchar(),
keywords varchar(),
};
and the advisors table structure is like below
table advisors{
id int(),
name varchar(),
specialties varchar(),
};
so I want the system to compare the titles keywords with advisor's specialties and decide who to assign to the group and I am confused on how to do that
