Learn HTML & SQL Query grouping techniques

Hi I am trying to learn, but as I am unsure of the correct terminology it’s difficult to know what search term to use to find answers.
For example…
I have a table of users.
I have a table of skills.

Each user can have more than one skill.

How do I design the database so I can store the user’s skills?

  • would I create a table to store the user’s skills and would this be called a ‘link’ or ‘group’ or ‘relationship’?

How do I create the CRUD HTML users view form to be able to add from the list of skills to the user?

  • sometimes you see on websites list boxes and an >> arrow to copy from one list box to another, what’s that called? and is it the correct way and how do you do it?

Hope you understand my questions and can help explain or even point me to an online tutorial site to learn how to do this. I am using Codeigniter as the framework fyi.

Thanks for your help and advice.

Sponsor our Newsletter | Privacy Policy | Terms of Service