Parsing Data

[Anon]

I am running into another brick wall... I am trying to store in mysql table which checked boxes are marked on, and store those in the database. But I have over 50 of them. So the best way(i think) would be to enter them as id of a different database, and seperate them by commas when stored. Like this.

checkboxes
+----+------+
| id | name |
+----+------+
| 1 | jake |
| 2 | nerd |
.............
+----+------+

and so on. Then stored when checked:

user
--------+
checked |
--------+
1, 4, 8 |
.........

and so on. But how would I go back and make it so that I can edit/view the checked ones again. How would I parse the data in the checked field?

Thanks again,
Jake

[Anon]

You would select the field from the DB and use the PHP function explode. You can look the function up on www.php.net if you need to. It breaks the data at the delimiter you specify into different elements of your array.

If you had 1,4,8 and called:

$array = explode(",", "1,4,8")

You would get:
$array[0]=>1
$array[1]=>4
$array[2]=>8