[eluser]Chris Newton[/eluser]
tonanbarbarian;
Right, but how would you write the sql query for that?
Ex;
Table A has 2 rows (news items)
Table B has 25 rows (category names)
Crossover table X has 17 rows, 13 of which relate to table A, 4 of which relate to table B
So.... how do you write a join that does the following; Respects the fact that there are only 2 items I'm interested in from table A (the news items), while adding an array of their corresponding categories stored in table X with names referenced in table B?
Every join that I could come up with ended up displaying multiple copies of the items from table A each with 1 category assigned to them. (rather than only 2 rows)
I could join everything, and then loop through it to pull out only the category information from multiple instances of the same data but that doesn't sound much better. Anyway. I'm gonna go try something... brb.