using GROUP_CONCAT

[phil kirkman]

I have a select query running from a search, dog by breed, where dogs is my main table, breeds is my breed table with a junction table dog_breed for the many to many relationship.

$breed = $_POST['breed'];



$query="
SELECT
dogs.dogID,
dogName,
sex,
young,
other,
dogDesc,
GROUP_CONCAT(
breeds.breed SEPARATOR ', '
)
AS dogBreeds,
sheltName
FROM
dogs,
dog_breed,
breeds,
shelters
WHERE
dogs.dogID = dog_breed.dogID
AND dog_breed.breedID = breeds.breedID
AND dogs.sheltID = shelters.sheltID
AND breeds.breed LIKE '%".$breed."%'
GROUP BY dog_breed.dogID
";

However, when I search on breed it's only returning the distint breed from the breeds table (e.g. 'dobermann' instead of 'dobermann, retriever'). I can't seem to find a workaround - I hope this makes sense as I'm a complete beginner at this. Thanks.