Need some DB help

[eluser]zilverdistel[/eluser]
[quote author="Firestorm ZERO" date="1205460489"]Yeah I know about bridge tables. I mentioned I am using a bridge table in my post.

I meant how are people grabbing the data from the 3 tables to display all the results on a page. I mentioned two methods in my posts above. I'm trying find the optimal method of doing so.[/quote]

I wouldn't use GROUP_CONCAT. 2 joins and a GROUP_BY should do it. To process the result array, see the example I gave in one of the first posts (a nested iteration). Does that answer your question?