@opensidex("Fødselsdage","on");

$result=dbquery(

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

"FROM ".$db_prefix."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 birth_month , birth_day LIMIT 0,3"

);

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

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

$months=explode("|", $locale['shortmonths']);

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

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

}

}

echo "</table>";

@closesidex();