Simple SQL question from a beginner...

[eluser]designcloud[/eluser]
I used this SQL...

Code:

SELECT p . * , c . *
FROM `profile` p
INNER JOIN `category_line` cl ON p.`profile_id` = cl.`profile_id`
INNER JOIN `category` c ON c.`category_id` = cl.`category_id`
ORDER BY p.`profile_id`
LIMIT 0 , 30

That worked. But now how do I now display in this format with the controller and view?

----------------------------
profile name
category name 1, category name 2, category name 3
----------------------------
profile name 2
category name 1, category name 2, category name 3
----------------------------
profile name 3
category name 3, category name 4, category name 7
----------------------------

etc.. any ideas? Im a beginner.