Multiple Indexes

[gladiatornado]

This question may sound trivial, but as a newbie I have been having a hard time finding an answer. Basically what I am trying to do is store multiple genre id's for a single CD. So lets say I have a CD table and a genre table. The CD I want to store has two different genres. I'd like to store both genre id's in a single field. Is this possible?

[TheDefender]

Yeah it's possible...

You would just take the various genre IDs and implode them into a single string, and store that value.

$genre[0] = "1";
$genre[1] = "2";
$genre[2] = "3";

$genres = implode(",", $genre);
echo $genres;

// OR

$genre1 = "1";
$genre2 = "2";

$genres = $genre1.",".$genre2;

Although the better route would be to store each genre ID separately if you want to do a query on it. It becomes more difficult if you are trying to search the field when it has them stored like this.

[gladiatornado]

Thanks for your help. The quering part has been my biggest concern. I initially thought about using enum, but I have been unsatisfied with that approach. I was hoping that this sort of thing is something that is done often. If creating multiple fields for the multiple genres is the best sollution then I will go with it!

Thanks again.