This month's birthdays / Upcoming Birthdays

[WhaLberg]

Here is the phpcode you need. Edit it for your own need.

PHP Code:

$month = date("m");
$find = $db->query_read("SELECT userid,username,birthday FROM " . TABLE_PREFIX . "user WHERE birthday LIKE '$month-%'");
while ($user = $db->fetch_array($find)) 
{
    $userid = $user['userid'];
    $username = $user['username'];
    $birthday = $user['birthday'];
    $birthday = explode("-", $birthday);
    $birthmonth = $birthday[0];
    if ($birthmonth = $month) 
    {
        echo "<a href='member.php?u=$userid'>$username</a>,&nbsp;";
    }
    
}