Posted by Geoff Berrow on 06/25/06 01:39

Message-ID: <1151197943.581310.88860@b68g2000cwa.googlegroups.com> from
frizzle contained the following:

>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.

It depends how you have structured your db. For a many to many
relationship like this you ideally need three tables, one for artists,
one for genres and one to link the two.

In the case above you would start with two rows in the link table.
Updating would require removing a row, though it may be simpler to
remove them all and then write a new one.



--
Geoff Berrow (put thecat out to email)
It's only Usenet, no one dies.
My opinions, not the committee's, mine.
Simple RFDs http://www.ckdog.co.uk/rfdmaker/

[Back to original message]