Working with Multi-Select & Dropdowns and SQL

[eluser]Bionicjoe[/eluser]
I'm really not much of a coder but CI is getting me places. However I am lost on using multi-select fields and dropdowns.

I think I'm good on dropdowns for now.

I have the multi-select fields and I can select an item and submit to the db table and repop the form with that value to edit. However I can only store one item. Choosing 2 or more items I usually get the first item selected. I'm just storing the values as text in my table.

I can't find a good tutorial or info on multi-selects & SQL. Usually just find basic info on creating the field.

Any help is greatly appreciated.