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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks my brother. You're always helpful
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.