single values into sql field

Posted on 16th Feb 2014 07:03 pm by admin

i have a form which i want the user to able to select multiple answers. But i want the answers to be stored into a single field on the mysql table in the back end. e.g

the user may select red + blue + green and so in the field i want it to show red,blue,green.

is it best to list the options in like an array or how do i do this as i dont do much PHP and so am a bit rusty.

hope you can help

Your Answer:

Login to answer

Other forums

getting rid of quotes in strings
sick of trying to deal with them in multiple ways (entering in and taking from database, echoing, ec

check if value exists
I have googled this for a while and I am getting lots of different results. Is there a standard meth

Splitting Attributes
SQL> SELECT I_NAME, substr(I_NAME,1,instr(I_NAME,'O')) "First part",

substr(I_NAME, IN

The page should be expire when cilck back button
hi,
i'm new to php world.
i create user registration page.
when i submit it,data goes to my

help with insert
Hi there,

I am trying to insert some data into a database, but for some reason, it is not ins

SQl num_rows problem
when i try to count rows from an SQL select i get an warning

Code: [Select]$countviews = mysq

Create PHP table grid help, please
I have a MySQL database setup, now it's time for the table (gridview) design in php. Here's the prob

Multi Dimensional Array Append
Hi Guys

I have a function that returns a multidimentional array eg

$result = functio

Multithreading design
Hi

I have come up with a Singleton class that manages a pool of database connections. Basical

Date help - fetch dates for Mondays between xxx and yyy?
Does anyone know the best way to do this? I have two dates, say:

2010-01-26 and 2010-05-30