|
Posted by frizzle on 06/25/06 01:12
Hi there,
I'm building a music site with a mysql backend. It has a many to many
relational database.
I use this to match music genres with certain artists, to maintain the
possibility to add multiple genres to a singe artist.
Now i've searched google, but can't find a solution on how to update
rows with checkboxes.
If an artist gets his genre updated as follows:
from
- [_] classic
- [X] rock
- [_] ballad
- [X] 80's
- [_] 90's
- etc.
to
- [_] classic
- [_] rock
- [_] ballad
- [_] 80's
- [X] 90's
etc.
wha t i wonder is how could i best create the backend. it would seem
inappropraite to run an update query for each possible box wether it's
checked or not.
frizzle.
Navigation:
[Reply to this message]
|