Hi there!
I have a database of members in a directory, and I'm looking to display members with the three closest birthdays on a sidebar (see attached screenshot). I'm not sure how to compare today's date to the birthdays in the database - I have it displaying birthdays in date order currently, and the list begins with January 1.
<?php
require_once "/home/kzoopeak/public_html/cmsAdmin/lib/viewer_functions.php"; list($member_directoryRecords, $member_directoryMetaData) = getRecords(array(
'tableName' => 'member_directory',
'limit' => '3',
'orderBy' => 'birthday ASC',
));?>
Is there an easy way to have it compare the birthday against today's date, and only display current or future birthdays? Thanks so much for your help!!
Kelly