hello I have an application run in php with mysql database that shows me a list of people in different services it occupies. I would like to make a menu that is based on the clicked service shows me the list of persons who holds this service and each new click the menu is updated with new people. In my database I created a table called person , it contains details of the person + all services available in the form of boolean fields. If the person holds such a service this field is set to 1 if not, that field is set to zero. if someone has an idea I'm interested , thank you in advance

Another thing I have not mentioned , the person table contains a field called score , the list of those to be displayed sorted by score

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.