Checkbox Values

[kbc1]

Hi all,

I store ID's in one varchar field as such:

1 2 3 4 8 11

How can I extract those ID values and display them as ticked checkboxes where the ID's of the checkboxes match the ID's in the field above?

Hope that makes sense - i'm really stuck!

Thanks in advance

[Weedpacket]

kbc1 wrote:

I store ID's in one varchar field

Bad move, and now you've discovered why (or, at least, one reason why). Have an additional table with one field for one of these IDs and one field that identifies which record its associated with. Then extracting the values is just a SELECT query like any other.

For more information, see this thread. Oh, and this one, also.