[eluser]vincej[/eluser]
Hi CroxNix - I am embarrassed to say that after trying umpteen different permutations I still can not make my query work. Yes, I know that this is not CI but none of my sources know how to make a double group_concat work with a join.
What I have got doesn't work properly. I get all the dates, all the PUIDs adn only 1 location:
Code:
ThePUID TheDates location
5,1,2,6,3,7,4,8 1331704800,1331704800,1333704800,1334704800,133570... Collingwood
My (faulty ) query so far is:
Code:
SELECT
GROUP_CONCAT( pudates.puid
order by pudates.dates asc) AS ThePUID,
GROUP_CONCAT( pudates.dates order by pudates.dates asc )
AS TheDates, locations.location
FROM pudates, locations
where locations.locationid = pudates.locationid;
could you please be so kind as to help out here ?
Many thanks !