Implode Explode function

[New_Coder]

Hi,
i insert 4 array to mysql database with checkbox(html) and implode() function.
no i have this mysql :

|id|name|user|
|1|php,mysql,python,web|25

this mysql data generate when user register. now user need after register edit this array in any time. how to show mysql result in checkbox? ( i know this worked with explode() function) how to work ?

Thanks

[laserlight]

You should not have multi-valued fields in your database. Rather, create another table in which each of those items are stored in separate rows.

[New_Coder]

laserlight;10971705 wrote:

You should not have multi-valued fields in your database. Rather, create another table in which each of those items are stored in separate rows.

lol. this is e.g 4 request database and server. how to advanced code for better database request with checkbox array?

[laserlight]

New Coder wrote:

this is e.g 4 request database and server. how to advanced code for better database request with checkbox array?

As I said, you create another table. Presumably you know what database/server options are already available, so you can pre-populate the rows in that table.

Now, I would think that there is a many to many relationship between users and each database/server option. Hence, you create a third table, a join table, to link each user with each option. So, the database/server options table is more or less fixed (i.e., you would only add rows once in a blue moon), but whenever you want to add a new user, you create a new row in the user table, and create a row in the join table for each option selected by the user.

When you want to display the selected options, you simply select from the join table those rows corresponding to the user's id. From there you can insert or delete rows as needed.