Display date on template results page
I have a PowerCMS template page set up to display a list of press releases. I would also like to display the date the press releases were added.
My recordset is as follows:
SELECT C2.ContentGroup, C2.ContentPageSetOrder, C2.ContentDate
FROM pcms2_contents AS C1 LEFT OUTER JOIN pcms2_contents AS C2 ON C2.ContentPagesetParentID = C1.ContentID
WHERE C1.ContentGroup = 'Press Releases'
GROUP BY C2.ContentPageSetOrder
ORDER BY C2.ContentDate DESC
To display the title of the release I have:
<?php
include('/var/www/vhosts/xxx.com/httpdocs/WA_CMS/addtosite.php');
echo WA_getCMSContent($database_PowerCMSConnection, $PowerCMSConnection, 'Press Releases', '1 Title', false, $row_rsReleases['ContentPageSetOrder'] ); $row_rsReleases['ContentPageSetOrder']
?>
How would I display the relevant date from the ContentDate column?