Following answer is relevant to me, Thanks and God bless all of you. Regards, Mobeen. ________________________________ From: php-objects@xxxxxxxxxxxxxxx [mailto:php-objects@xxxxxxxxxxxxxxx] On Behalf Of Pete Sent: 12 May 2009 23:49 To: php-objects@xxxxxxxxxxxxxxx Subject: Re: Concatenate a char field? In message <4A09A9E8.8090705@xxxxxxxxxxx<mailto:4A09A9E8.8090705%40icondal.com>>, jan <os2@xxxxxxxxxxx<mailto:os2%40icondal.com>> writes >Pete escribió: >> >Try with this mysql function: > >http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html#function_group- >concat I didn't think that would work without a group. But I just tried it, and it does! Well spotted. SELECT GROUP_CONCAT(xField) FROM mytable; -- Pete Clark Got any spare time? Anything you need? Barter in Spain Join for free at http://BarterWithBart.com [Non-text portions of this message have been removed]
