Need Help With Form Submission

[eluser]vincej[/eluser]
HI again - It Looks Like I have success!!

It's a been a pig though ! I resorted to my old fashioned 'where' clauses rather than the more current joins ( yes I am that old ! ) and it all fell into place :o)

check it out !

Code:

SELECT group_concat(p.puid ORDER BY p.dates) AS ID, location, l.locationid, group_concat(p.dates ORDER BY p.dates) as Dates
FROM locations l, pudates p
WHERE l.locationid = p.locationid
GROUP BY  location;

Many Thanks !!!!