<?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);
?>