Concat maybe?

[NancyJ]

Theres a way in mysql to get a comma separated list of fields in a one to many relationship - rather than multiple rows for each record in the 'one' table. But I can't remember what it is, I thought it was concat but that didn't work... I've done it before but I can't remember what it was or why.

[CFMaBiSmAd]

Probably this one - GROUP_CONCAT(expr)

[NancyJ]

thats the bunny! I was close.

[NancyJ]

...where did the thank you button go?

[CFMaBiSmAd]

Probably a casualty of the hacking the forum suffered (there were two thank you buttons at one point yesterday.)