Welcome Guest, Not a member yet? Register   Sign In
Need Help With Form Submission
#13

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


Messages In This Thread
Need Help With Form Submission - by El Forum - 03-19-2012, 11:43 AM
Need Help With Form Submission - by El Forum - 03-19-2012, 12:56 PM
Need Help With Form Submission - by El Forum - 03-19-2012, 03:00 PM
Need Help With Form Submission - by El Forum - 03-19-2012, 03:33 PM
Need Help With Form Submission - by El Forum - 03-19-2012, 03:40 PM
Need Help With Form Submission - by El Forum - 03-19-2012, 04:03 PM
Need Help With Form Submission - by El Forum - 03-19-2012, 04:15 PM
Need Help With Form Submission - by El Forum - 03-19-2012, 04:44 PM
Need Help With Form Submission - by El Forum - 03-20-2012, 12:26 PM
Need Help With Form Submission - by El Forum - 03-20-2012, 12:48 PM
Need Help With Form Submission - by El Forum - 03-20-2012, 02:06 PM
Need Help With Form Submission - by El Forum - 03-20-2012, 02:15 PM
Need Help With Form Submission - by El Forum - 03-21-2012, 01:30 PM
Need Help With Form Submission - by El Forum - 03-21-2012, 03:01 PM



Theme © iAndrew 2016 - Forum software by © MyBB