combine multiple row that have same id

[Redcircle]

I am curious on what you are trying to accomplish with this data. There may be a way if I know the end results.

[Romantik]

I think, you have wrong structure of base

table name
id name
1 Matt
2 Sarah
3 Tom

table surname
id ind name
1 1 John
2 2 Gina

where name.id=surname.ind

SELECT name.name AS name, surname.name AS surname
FROM name INNER JOIN surname ON name.id=surname.ind
ORDER BY name.id

while($row=......
{
$name= $row["name"];
$surname= $row["surname"];
echo $name." ".$surname."<BR>";
}