[Solved] mySQL data type for form elements

by

[ad_1]

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

[ad_2]

solved mySQL data type for form elements