Preparing a database table
In order to create a drop-down list in a Job in the following examples, you should have a
Mysql database.
Before replicating the following examples, make sure you have created a Mysql table named employee. The table stores people information as shown below.
| id | name | sex | department | position | |
|---|---|---|---|---|---|
| 1 | Elisa | elisa@company.com | F | RD | manager |
| 2 | Nicolas | nicolas@company.com | M | RD | developer |
| 3 | Sabrina | sabrina@company.com | F | Community | developer |
| 4 | Stephane | stephane@company.com | M | Sales | manager |
| 5 | Jim | jim@company.com | M | Sales | pre-sales |