How to insert multiple coma separated value in one particular column of DB - Page 2

crewson548 · 10-29-2012, 01:22 PM

Quote:

Originally Posted by Coyote6

I agree with guelphdad... bad idea.

But... where it's messing up is you must treat the ids as a string therefore the must be enclosed in quotes.

"asd",1,"1,2,4","444")

Yes I totally agree with your statement.. it really mess with one another.. Can u suggest me this same process in PHP script..

Old Pedant · 10-30-2012, 02:05 AM

Quote:

Originally Posted by crewson548

Yes I totally agree with your statement.. it really mess with one another.. Can u suggest me this same process in PHP script..

No. The whole point is to *NOT* do this. PERIOD.

Can you work around it with PHP code? Yes, but ONLY by reading EVERY RECORD in the table and having PHP process EVERY RECORD.

DON'T DO IT.

You say you agree with the statement and then you try to find a way around it. That makes no sense.