title: User System - Multiple Roles in MySQL Database
body: <p>So I am in the process of attempting to create a basic user system and within this system I want users to be able to have multiple roles.</p>
  
  <p>Say for example I have the roles as follows: Administrator, Events Organiser, Donator</p>
  
  <p>What is the best way to assign these multiple roles to a user and then check if they have any of these roles for showing certain permissions.</p>
  
  <p>If it was only one role per person then it wouldn't be a problem as I'd just assign say Administrator = 10, Organiser = 5 and Donator = 1 and then do an if statement to check if the MySQL data is equal to any of those three numbers.</p>
  
  <p>I can't imagine there is a way to add a MySQL Field and fill it with say "Administrator,Donator" and therefore that user would have both of those roles? </p>
  
  <p>Is it just a case of I would need to create 3 separate fields and put a 0 or a 1 in those fields and check each one separately?</p>