[Resolved] Repeat printing

[hayato1]

Hm i don't know why i got this.

Example:
+-------------------------------------+
| John | Age-18 | Male | T-shirt |
+-------------------------------------+
| John | Age-18 | Male | -Jeans |
+-------------------------------------+
| John | Age-18 | Male | -Boots |
+-------------------------------------+

Is it possible that i have this? Rather than repeating 3 John?
+------------------------------------------------------+
| John | Age-18 | Male | T-shirt, Jeans, Boots |
+------------------------------------------------------+
| Jack | Age-24 | Male | Jacket , Shirt , Pants |
+------------------------------------------------------+

Thankxs in advanced

[LordShryku]

Might be able to utilize concat_ws. Otherwise, you'll have to do some logical operations in your loop.

[hayato1]

I'm died how to use this

CONCAT_WS(separator, str1, str2,...)
CONCAT_WS() stands for CONCAT With Separator and is a special form of CONCAT(). The first argument is the separator for the rest of the arguments. The separator is added between the strings to be concatenated. The separator can be a string as can the rest of the arguments. If the separator is NULL, the result is NULL. The function skips any NULL values after the separator argument.
mysql> SELECT CONCAT_WS(',',
'First name','Second name','Last Name');
-> 'First name,Second name,Last Name'
mysql> SELECT CONCAT_WS(',','First name',NULL,'Last Name');
-> 'First name,Last Name'

i guess no hope....
----------edited
I tried the result is same

still

John ,caps
John ,jeans
John ,pants
Jack ,caps
Jack ,jeans

Jack ,pants

rather than

John , Caps, jeans ,Pant
Jack , Caps, jeans ,Pant

[LordShryku]

Sorry, meant to point you to group_concat. It requires MySQL version 4.1 though.

[hayato1]

I'm using
MySQL 4.1.1a-alpha-max
i read that group concat, but catch no balls what is it going or how to apply inside.

[hayato1]

Thanks Dude your leading me to the right paths helps alot
I'm done from reading 48hrs of articals
and found my last answer following here

SELECT name, group_concat(style ORDER BY style SEPARATOR " ") as styles FROM person LEFT join shirt ON (person.id=shirt.owner) GROUP BY shirt.owner;