+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: Need some DB help (/showthread.php?tid=6821)
Pages:
1
2
Need some DB help - El Forum - 03-13-2008
[eluser]Firestorm ZERO[/eluser]
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.
Need some DB help - El Forum - 03-13-2008
[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?