Verjaardagen tonen (Opgelost)

$qry = mysql_query("SELECT * FROM leden WHERE MONTH(geboorte) = MONTH (NOW())") or die (MySQL_Error())

$qry = mysql_query("SELECT * FROM leden WHERE MONTH(geboorte) = MONTH (NOW())") or die (MySQL_Error())

SELECT name, birthday
FROM users
WHERE DATEDIFF(CURDATE(), birthday) < 28

SELECT name, birthday
FROM users
WHERE DATEDIFF(CURDATE(), birthday) < 28

SELECT name, birthday
FROM users
WHERE DATEDIFF(DATE_FORMAT(CURDATE(), '%c-%e'), DATE_FORMAT(birthday, '%c-%e')) < 28

SELECT name, birthday
FROM users
WHERE DATEDIFF(DATE_FORMAT(CURDATE(), '%c-%e'), DATE_FORMAT(birthday, '%c-%e')) < 28

SELECT * FROM leden WHERE (cnv_datkort($datum) >= strftime('%d-%m') AND (cnv_datkort($datum) < strftime('%d-%m') + INTERVAL 4 WEEK)"

SELECT * FROM leden WHERE (cnv_datkort($datum) >= strftime('%d-%m') AND (cnv_datkort($datum) < strftime('%d-%m') + INTERVAL 4 WEEK)"

function cnv_datkort($datum)
{
    // datum opsplitsen en valideren             ( ':' weglaten )
    $da1 = substr($datum, 0, 4); // jaren     (Y)
    $da2 = substr($datum, 5, 2); // maanden   (m)
    $da3 = substr($datum, 8, 2); // dagen     (d)
    $datum = $da3 . "-" . $da2;
    return $datum;
}

function cnv_datkort($datum)
{
    // datum opsplitsen en valideren             ( ':' weglaten )
    $da1 = substr($datum, 0, 4); // jaren     (Y)
    $da2 = substr($datum, 5, 2); // maanden   (m)
    $da3 = substr($datum, 8, 2); // dagen     (d)
    $datum = $da3 . "-" . $da2;
    return $datum;
}