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){

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>";

}

[b]}

echo "</table>";[/b]