April 21st, 2003, 09:00 PM
I have three tables
Each news story will have 1 or more categories associated with it.
I would like to produce output that looks like
CategoryName1, CategoryName 7, ... CategoryNamex This is News Story 1
CategoryName2 This is News Story 2
CategoryName5, CategoryName11 This is News Story 3
Should I handle creating the list of categories in code can I do it in a query?
I am using mysql so stored procedures are not an option at the moment for me.