Hi.
I assume, by your use of the checkboxes, that you mean each film to have multiple genres?
A single field in a database should never contain more then a single piece of data, meaning that a single "genre" field would not be enough for this information.
You could always cheat on this by serializing all the data and storing it as one string
(which is what the implode function does), but that's just not... sanitary ;-)
The "best" solution for something like this is to create a separate table for the genres and link it to the film table.
-
+--------+ +------------+
-
| Film | | FilmGenre | +---------+
-
+--------+ +------------+ | Genre |
-
| FilmID |<-->| FilmID_FK | +---------+
-
| Title | | GenreID_FK |<-->| GenreID |
-
| Date | +------------+ | Name |
-
| Etc... | +---------+
-
+--------+
There you would just add all the Genres to the Genre table, all the Films to the Film table, and then a row in the FilmGenre table for each genre a film should have.
P.S.
You should read up on
SQL Injection. You code is wide open to it.
The short version; Don't put anything into a MySQL query before running it through the
mysql_real_escape_string function.
