I've never built temporary tables before but maybe this is the best way to achieve the following using PHP & MYSQL:

Goal: Have a dynamic list to check boxes which will be inserted into one field in the DB coma separates!

For example; I have check boxes for red(1), green(2), blue(3) and yellow(4). I want the client to select as many as they wish and insert the numbers into one field in the DB. So the field colors might have a value of 1,3,4.


I need a tutorial for temporary tables.
Any ideas

Nick

or
red(1), green(2), blue(4) and yellow(8)
so 3 = red + green, 15 = red + green + blue + yellow and so on., however using this approach you will only be able to store the colour once, you couldnt' say have two yellows
and use a bitfield datatype
or do the bit manipulation in the PHP presentation layer

Can you point me to an explanation and example?

Thank

something you should read ---> this