manipulating mysql_fetch_array

[slanton]

Say I had a table like

Fred dog

Paul cat

Mark cat

Fred fish

Paul dog

and used a query like

//$query = "SELECT name, pet FROM clients";
$result = mysql_query($query) or die(mysql_error());
while($row = mysql_fetch_array($result)){
extract($row);
echo $name;
echo $pet;
}

I would get each row as

Fred dog,

Paul cat,

Mark cat

Fred fish

Paul dog

 

What I am trying to get is an array for each name something like

Fred dog fish,

Paul cat dog,

Mark cat.

I can't figure it out! Anyone?

[p2grace]

Try this for your query:

 

<?php
$query = "SELECT name, pet FROM clients GROUP BY `name`";
?>

[slanton]

Using GROUP BY will only return me 3 rows without all the columns

eg

Paul cat

Mark cat

[sasa]

try

//$query = "SELECT name, pet FROM clients";
$result = mysql_query($query) or die(mysql_error());
while($row = mysql_fetch_array($result)){
extract($row);
//echo $name;
//echo $pet;
$org_arr[$name][] = $pet;
}
foreach ($org_arr as $name => $pets){
echo $name, ' - ', implode(', ', $pets), "<br />\n";
}

[slanton]

Yes thanks that did it.

[Barand]

or

 

SELECT name, GROUP_CONCAT(pet SEPARATOR ', ') as pets FROM clients GROUP BY name

[slanton]

Hi Barand

Thanks for that!