Clansphere :: FREE Clan Content Management System

$cs_users = "SELECT users_id, users_nick, users_age, access_id,
DATE_FORMAT( users_age, '%m%d' )
AS MoTa
FROM cs_users
WHERE DATE_FORMAT( users_age, '%m%d' ) >= DATE_FORMAT( CURRENT_DATE, '%m%d' ) and users_hidden NOT LIKE '%users_age%' AND users_age != '0' AND users_active = '1' AND (access_id >= " . $birthday_options['access_level'] . ")
ORDER BY MoTa
LIMIT ".$birthday_options['max_users'];

$ergebnis = mysql_query ($cs_users);
$nr = mysql_num_rows($ergebnis);

$thisyear = date("Y");
while ($row = mysql_fetch_row($ergebnis)) {
$birth = explode('-', $row[2]);
$newage = $thisyear-$birth[0];
echo $row[1].' ('.$newage.'), ';
}
if ($nr < $birthday_options['max_users']){
$rest = $birthday_options['max_users'] - $nr;
$cs_usersb = "SELECT users_id, users_nick, users_age, access_id,
DATE_FORMAT( users_age, '%m%d' )
AS MoTa
FROM cs_users
WHERE DATE_FORMAT( users_age, '%m%d' ) >= '0101' and users_hidden NOT LIKE '%users_age%' AND users_age != '0' AND users_active = '1' AND (access_id >= " . $birthday_options['access_level'] . ")
ORDER BY MoTa
LIMIT ".$rest;
$ergebnis2 = mysql_query ($cs_usersb);
while ($row = mysql_fetch_row($ergebnis2)) {
$birth = explode('-', $row[2]);
$newage = $thisyear+1-$birth[0];
echo $row[1].' ('.$newage.'), ';
}
}