Sql显示结果为1行而不是重复

Question

Hello i have a table like this

Name  | Date       | Email
------+------------+------
Dima  | 2013-04-01 | [e-mail]
Dima  | 2013-07-03 | [e-mail]
Dima  | 2013-03-06 | [e-mail]
Andrei| 2013-01-28 | [e-mail]
Andrei| 2013-01-12 | [e-mail]

echo'<table>';
$stmt = $dbh->prepare("SELECT * FROM Users"); 
$stmt->execute();
while ($row = $stmt->fetch())
            {   
$name=$row['Name'];
$date=$row['Date'];
$email=$row['Email'];
<tr>
<td>'.$name.'</td>
<td>'.$date.'</td>
<td>'.$email.'</td>
</tr>
            }
echo'</table>';

This query will display me the exact table from database, what i want is to display all the info related to Dima for example to one row

Dima \ 2013-04-01, 2013-07-03, 2013-03-06 \ [e-mail]

Answer 1

you can use GROUP_CONCAT

SELECT Name, GROUP_CONCAT(Date) Date, Email
FROM TableName
GROUP BY Name, Email