I have 2 editors.
editor 1: dancer_schedule - show_date, dancers (checkbox list from editor 2)
editor 2: dancers - name, photo, content
In editor 1:
Show Date: calendar picker, you select month, day, year
Dancer Selection: checkbox list of 5 dancers, coming from editor 2
Announcement: just a text field for any notes
I want the viewer to display on the page like this:
NOVEMBER
Thu, Nov 4th: Jen, Haley
Fri, Nov 5th: Haley, Jessica
Sat, Nov 6th: Jessica
Thu, Nov 11th: Rachel, Jen
DECEMBER
Thu, Dec 2nd: Rachel, Jen
Fri, Dec 3rd: Haley
Sat, Dec 4th: Haley
Thu, Dec 9th: Jen, Jessica
Fri, Dec 10th: Jen
I can get a simple list to display easily but I don't know how to get them to display by month, under a month title like above.
list($dancer_scheduleRecords, $dancer_scheduleMetaData) = getRecords(array(
'tableName' => 'dancer_schedule',
'loadUploads' => true,
'allowSearch' => false,
'where' => " show_date >= CURDATE() ",
));
list($dancersRecords, $dancersMetaData) = getRecords(array(
'tableName' => 'dancers',
'loadUploads' => true,
'allowSearch' => false,
));
<?php foreach ($dancer_scheduleRecords as $record): ?>
<strong><?php echo date("D, M jS", strtotime($record['show_date'])) ?>: </strong>
<?php echo join(', ', $record['dancers:labels']); ?><br>
<?php endforeach ?>