Viser Fødselsdage men uden Flag kun tekst
 Kode@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();
|
Billede ind i profil
Danish
English
