group_concat(A,' ',B,' ',C) as Name,
then using this php for displaying
<td><?php echo $row['Name']; ?></td>
using this query returns Name X,Y
but i prefer to have the names not comma separated rather line break X then Y new line
I don't understand what do you mean by line break between X and Y, but if you don'e need comma separated you can Add any separator to the Group_Concat like that:
group_concat(Name SEPARATOR ' ') as Name
and here is Some other Separators you can use.