[Solved] mySQL data type for form elements

by


1) you will get string as the value of radio so it will be varchar type

2) for check boxes any one can have multiple values so you need to create a separate table(working_project) for this values( data type will be same as radio) and another table for mapping(user_working_project)

user_working_project table will containing user id and working project id

e.g one user has id=1, and working_project=1,2

then in your user_working_project table entries will be like this:

  user_working_project_id working_project_id user_id
  1                         1                    1
  2                         2                    1

solved mySQL data type for form elements