saving different dropdown in UI into one one column in database
Name : ____txt Location : _____txt Job type : ______(dropdown
-office,mobile,home)
Post Details for Office ( this will appear when office selected in job type)
job tile office : ______(dropdown connected to server A)
Post details for Home ( appear when home selected in job type) Job tile
home: _____ (dropdown connected to server B)
Post details for mobile (appear when mobile selected in job type) job
title mobile: _____ (dropdown connected to server C)
this should be inserted in to a new table
insert into (name,location,job_type,job_title) values
(name,location,jobtype,jobtitle).
here in this insert command jobtitle is related to all three dropdown
home,office,mobile) at a time only one can selected. but I need to store
the job title into one column no matter which dropdown is selected.
No comments:
Post a Comment