checkboxes data in datbase?. How can I match with search criteria?

[phpsharma]

Hi,

INSERT form:I have a form with 5 checkboxes. I am storing it in datbase as varchar by combining all checked values with ":"(EX:0:1:2:4). Till here its ok

I am storing data in schoolstate feild with data (0:3).

Now I have a SEARCH form where i will give above 5 check boxes as critera. Now i Strucked at comparing these values to get results.

Now i am not able to get matched records with 0,3 criteria in search form. I am not getting any ideas how to do this?

Please help me. Thanks In advance.

sharma

[Jasp182]

for this type of thing I use bit flag constants and store the field as an integer. once you get the integer back, you can simply use bit-wise comparators to check the presence of each flag

http://us2.php.net/language.operators.bitwise