How to join a tableA.id on a serialized tableB field???

Hi,

Storing multiple colors with checkboxes and store the colors as serialize data and unserialize to repopulate the form checkboxes.

For this, i have a tableA with colorID and colorName

In tableB i store a serialized array with multiple colorID's in field colors.

How do return the colorName with on query??

Select tableA.colorID as colorID, tableA.colorName as colorName FROM tableA JOIN ....

Code (markup):

Hope you understand my question

 

did you use php to serialize data from table b?

 

yes, i used php serialized function

 

I would like to know this too...

I'm developing something similar and I'm using serialized arrays to be stored on mysql and wonder how to accomplish that.

Thanks!

 

Please show some data in your tables giving an example like this

Table A
colorID     colorName
1                 Red
2                 Green
3                 Blue
4                 Yellow

Table B
The fields you are using....

Code (markup):

So you will write all the column names you are using on these two tables.....

I will try to help you.

Thanks,

Jimmy