Hi Jason and Daryl
Thanks for this thread - have been trying to implement this but its not showing on the live page.
I have a template group in PCMS called Blog Items
I have created a recordset ( BlogRS ) for the Blog Items to be shown on the page.
I created a 2nd recordset ( BlogMenuRS ) to create the menu system mentioned in this thread.
This is the code I used for the BlogMenuRS recordset:
SELECT Date_format(pcms2_contents.ContentDate, '%M, %Y') as contDate, COUNT(*) AS ccFROM pcms2_contents
WHERE pcms2_contents.ContentPageName='Blog Items' AND pcms2_contents.ContentPageSetParentID=12
GROUP BY YEAR(pcms2_contents.ContentDate), MONTH(pcms2_contents.ContentDate)
ORDER BY pcms2_contents.ContentDate DESC
and this is your code amended to reflect my recordset:
php:
<?php
// RepeatSelectionCounter_1 Begin Loop
$RepeatSelectionCounter_1_IterationsRemaining = $RepeatSelectionCounter_1_Iterations;
while($RepeatSelectionCounter_1_IterationsRemaining--){
if($RepeatSelectionCounterBasedLooping_1 || $row_BlogMenuRS){
?>
<?php echo $row_BlogMenuRS['contDate']; ?> (<?php echo $row_BlogMenuRS['cc']; ?>)<br/>
<?php
} // RepeatSelectionCounter_1 Begin Alternate Content
else{
?>
<?php } // RepeatSelectionCounter_1 End Alternate Content
if(!$RepeatSelectionCounterBasedLooping_1 && $RepeatSelectionCounter_1_IterationsRemaining != 0){
if(!$row_BlogMenuRS && $RepeatSelectionCounter_1_Iterations == -1){$RepeatSelectionCounter_1_IterationsRemaining = 0;}
$row_BlogMenuRS = mysql_fetch_assoc($BlogMenuRS);
}
$RepeatSelectionCounter_1++;
} // RepeatSelectionCounter_1 End Loop
?>
But for some reason, its not displaying on the live page.... obviously I have either not done something or done it incorrectly and would appreciate your help please
Many thanks
Jamie
