Registration

I am new to the PHP world and as I am developing for friends and family I get questions on can certain functions be done and one has come to me recently which I do not know how to structure.

As you know my heading talks about registration.

I have already developed where someone can register by placing their name, address, phone number and e-mail. However, now it is going a little further which I do not know what is the structure for PHP and MySQL.

For example, I know if I wanted a name field it is a VARCHAR in MySQL, and if I wanted a yes or no I can use a checkbox field and that would by a tinyint in MySQL. The confusion for me is how do I set up the database for when you see registration where they ask for what is your favorite sports and there is a list of checkboxes and at the bottom there is a check box that says all and some how you see the checkbox has a check mark in all the boxes. How is this set up within PHP or I guess it will be HTML form tag. What I do not understand is what is the structure that if you have more than one checkbox which can be different interests, how does that get applied to the database of MySQL, is it a VARCHAR, or INT or even LONGTEXT? How does this get setup for registration applications? This is where I need guidance.

Can someone guide me in this, it is greatly appreciated.

Thank you,
AdonaiEchad