echo "<b>Nadchodz&#177;ce urodziny:</b>";



$result=dbquery(

"SELECT user_id, user_name, DATE_FORMAT(user_birthdate, '%d') AS birth_day, EXTRACT(MONTH FROM user_birthdate) AS birth_month ".

"FROM ".$fusion_prefix."fusion_users ".

"WHERE EXTRACT(MONTH FROM user_birthdate)>EXTRACT(MONTH FROM NOW()) OR ".

"(EXTRACT(MONTH FROM user_birthdate)=EXTRACT(MONTH FROM NOW()) AND EXTRACT(DAY FROM user_birthdate)>=EXTRACT(DAY FROM NOW())) ".

"ORDER BY EXTRACT(MONTH FROM user_birthdate),EXTRACT(DAY FROM user_birthdate) LIMIT 0,5"

);

echo "<table width='100%' cellpadding='0' cellspacing='0'>";

if(dbrows($result)!=0){

$months=explode("|",LAN_SHORTMONTHS);

while($data=dbarray($result)){

echo "<tr><td class='small' align='left'><a href='".BASEDIR."profile.php?lookup=".$data['user_id']."'>".$data['user_name'];

echo "</a></td><td class='small2' align='right'>".$data['birth_day'].". ".$data['birth_month']."</td></tr>";

}