Link to home
Start Free TrialLog in
Avatar of Opeyemi AbdulRasheed
Opeyemi AbdulRasheed

asked on

Multiple data in a single MySQL column as Dropdown Options

Hello Experts,
Is it possible to use multiple data from a single MySQL field separated by comma such as (PHP,MySQL,Ajax,jQuery) as dropdown options?

The column name is "Skills" and has multiple data as described above. What I want is that, I want to be able to use each data in this column as dropdown Options in the form.

How do I use Select?

Thanks.
Avatar of ste5an
ste5an
Flag of Germany image

What have you coded so far? What kind of architecture do you use?

You need to split the values either in PHP or on the web page using JavaScript.

btw, it is a bad table desgin. It violates 1NF.
ASKER CERTIFIED SOLUTION
Avatar of Chris Stanyon
Chris Stanyon
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Opeyemi AbdulRasheed
Opeyemi AbdulRasheed

ASKER

Thanks my brother. You're always helpful