SELECT Date_format(pcms2_contents.ContentDate, '%M, %Y'),
should be:
SELECT Date_format(pcms2_contents.ContentDate, '%M, %Y') as contDate,
then:
<?php echo $row_Recordset1['Date_format(pcms2_contents.ContentDate, '%M, %Y')']; ?>
would be:
<?php echo $row_Recordset1['contDate']; ?>