Looping through left joined tables

[eluser]sophistry[/eluser]
oh yeah, and you might look at GROUP_CONCAT if you have mysql 4.1+ - that would let you do something similar in SQL:

http://www.mysqlperformanceblog.com/2006...extension/

EDIT: be sure to read the comments at the bottom of that page: there is a limitation of 1024 characters when using group_concat