# MySQL / PHP getting multiple selections into the database

**URL:** <https://forum.kirupa.com/t/mysql-php-getting-multiple-selections-into-the-database/189468>\
**Category:** programming\
**Created:** [June 2, 2006, 8:50pm UTC](https://forum.kirupa.com/t/mysql-php-getting-multiple-selections-into-the-database/189468 "2006-06-02T20:50:06Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![halian](https://avatars.discourse-cdn.com/v4/letter/h/45deac/32.png) [@halian](https://forum.kirupa.com/u/halian)\
**Post date:** [June 2, 2006, 8:50pm UTC](https://forum.kirupa.com/t/mysql-php-getting-multiple-selections-into-the-database/189468/1 "2006-06-02T20:50:06Z")

</div>

I created a sql column:  
options enum (‘option1’,‘option2’,‘option3’,‘option4’);

and i have a list item in a php doc that allows multiple selections. my problem is that it only adds the last item selected to the database. How do i get it to add all the selected items to the database?