Thanks Craig,
Someone has been helping out somewhere else with the SQL, and almost got it working using this SQL:
SELECT itineraries.ItineraryID
, itineraries.Itinerary
,itineraries.ItineraryID
, itineraries.Itinerary
, itineraries.Summary
, itineraries.Currency
, itineraries.Price
, itineraries.Duration
, itineraries.Publish_GSG
, itineraries.Image3
, GROUP_CONCAT(
CONCAT_WS(':',activities.icon)
SEPARATOR '<br />'
)
AS flags
, GROUP_CONCAT(
CONCAT_WS(':',activities.activity)
SEPARATOR '<br />'
)
AS countries
FROM itineraries
INNER JOIN ItineraryActivities
ON ItineraryActivities.ItineraryID = itineraries.ItineraryID
INNER JOIN activities
ON activities.ActivityID = ItineraryActivities.ActivityID
AND activities.Category = 'Countries Visited'
WHERE itineraries.Publish_GSG = 'Yes'
GROUP
BY itineraries.ItineraryID
Which works here:
http://www.goodsafariguide.net/itineraries_beta/index801.php
But something goes AWOL when I try to display the little flag icons - it only displays them if there is only one country listed, which seems weird as the text from the field is displaying correctly above.
http://www.goodsafariguide.net/itineraries_beta/index802.php
Will have a look at your link and see how I go with that.