Link to home
Start Free TrialLog in
Avatar of remedy_rider
remedy_riderFlag for United States of America

asked on

Adding multiple values into one field using mysql

Hello, I am fairly new to php and mysql. I noticed that when taking values from a form and inserting into mysql, it will not take multiple values and comma sperate them. in ms sql I had a form for example. "Which colors do you like" with check boxes red, green, blue, yellow, black
It would put them in the field "perfered_colors" as comma sperated. In my mysql insert it just puts one of the values? I'm sure this is an easy solution
ASKER CERTIFIED SOLUTION
Avatar of john-formby
john-formby
Flag of Ghana 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 remedy_rider

ASKER

Thanks!
I'll give that a shot.

 I thought it could be as easy as a line of code, but i guess there are diferences going from sql to mysql.