I have added a custom field with about 50 checkbox items. I have specified a SQL type of VARCHAR. However, when I do this, the values that are selected in the member profile will not save. Not only that, the SQL type keeps reverting back to BLOB any time I run the Repair DB. Anyone know what the problem is? We need to be able to have users specify multiple categories from this list of checkboxes. Is there a different way we need to setup the field to make it work?
Checkbox items can only be stored inside an "Common" type field. It will not work with "SQL" fields, because actual value is an php array. Which aMember Pro version are you using? Latest version would not let you to do that incorrect.
As soon as I updated to 4.2.1 it forced me to use a common type. However, maybe you can help me with something somewhat related. The reason why I wanted to use SQL is because I've had a hard time parsing through the member data in the "data" field of the member table. Do you have any php code or instructions for parsing through that. I'm just trying to format the member data and output it to a special web page we've setup. It looks like a standard format that I've seen before, but I'm having a hard time with it.
it is very easy, it is just serialized. $unencoded_data = unserialize($data); print_r($unencoded_data); and back $data = serialize($data); // then escape and you may write it to sql