[Funjoy]

Hallo,

Danke für deine Antwort habe aber mal in der MySQL Doku geschaut und bin auf Like gestoßen :-)

Habe das Problem so glößt:

PHP-Code:

<?php 
//> Geburtstagkinder ausgeben.
$month = array("","Januar","Februar","M&auml;rz","April","Mai","Juni","Juli","August","September","Oktober","November","Dezember");
$smarty->assign("month",$month[sprintf("%d",date("m"))]);
$result_b_user = $DB->dbQuery("SELECT memberid,born,firstname,surname,lower_surname,lower_firstname FROM ".$mysql_prefix."members WHERE born LIKE '%.".sprintf("%d",date("m")).".%' ORDER BY surname,firstname");
while($b_member = $DB->dbFetchArray($result_b_user)) {
    if($b_member['lower_surname'] == TRUE) {
        $surname = $b_member['surname']{0}.".";
    } else {
        $surname = $b_member['surname'];
    }
        
    if($b_member['lower_firstname'] == TRUE) {
        $firstname = $b_member['firstname']{0}.".";
    } else {
        $firstname = $b_member['firstname'];
    }
        
    $b_user_content[] = array("ID" => $b_member['memberid'],
                              "NAME" => ucfirst($surname)." ".ucfirst($firstname));
}

if(isset($b_user_content)) {
    $smarty->assign("b_user_content",$b_user_content);
} else {
    $smarty->assign("default_b_user","Keine");
}
?>

MfG Funjoy