Hi Jason
I ended up using;
SELECT Date_format(pcms2_contents.ContentDate, '%M, %Y'), COUNT(*) AS cc FROM pcms2_contents WHERE pcms2_contents.ContentPageName='News' AND pcms2_contents.ContentPageSetParentID=12 GROUP BY YEAR(pcms2_contents.ContentDate), MONTH(pcms2_contents.ContentDate) ORDER BY COUNT(*) DESC, pcms2_contents.ContentDate DESC
When I tested this in DW it displayed the results as expected, however when I tried to add the results to a page it didnt work.
The code I was using was created by DW....
<?php echo $row_Recordset1['Date_format(pcms2_contents.ContentDate, '%M, %Y')']; ?> (<?php echo $row_Recordset1['cc']; ?>)
It appears to be
<?php echo $row_Recordset1['Date_format(pcms2_contents.ContentDate, '%M, %Y')']; ?>
that is breaking the page.
