Location: PHPKode > scripts > WH Social > wh_social/modules/birthday.inc.php
<?php

    $bday = "SELECT
                 id,
                 name,
                 birthday
             FROM
                 members
             WHERE
                 DATE_FORMAT(birthday,'%d-%m') = DATE_FORMAT(CURDATE(),'%d-%m')";

    $resultb = mysql_query($bday) OR die(mysql_error());

    if(!$resultb) {

    echo '<p>' . $lang['no_birthdays'] . '</p>';

        }else{

        if(mysql_num_rows($resultb) == 0) {

        echo '<p>' . $lang['no_birthdays'] . '</p>';

    }else{

    while($row = mysql_fetch_assoc($resultb)) {

        echo '<p><a href="member.php?id=' . (int)$row['id'] . '">' . htmlentities($row['name'], ENT_QUOTES) . '</a></p>';
        }
    }
    }

    mysql_free_result($resultb);

?>
Return current item: WH Social