Need Help With Form Submission

[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 !