Changeset 101

Show
Ignore:
Timestamp:
2007-12-13 16:35:31 (1 year ago)
Author:
hannes
Message:

calculating correct age of members (ticket #41)

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • trunk/classes/pages/Page.php

    r99 r101  
    291291            $_today->modify($_offset); 
    292292            // get members with this month-day combination 
    293             $q = $C->prepare('SELECT memberid, membername, SUBSTR(birthday,0,4) AS year FROM ' . $SETTINGS['dbtableprefix'] . 'members WHERE SUBSTR(birthday,6,5) = :today'); 
     293            $q = $C->prepare('SELECT memberid, membername, SUBSTR(birthday,1,4) AS year FROM ' . $SETTINGS['dbtableprefix'] . 'members WHERE SUBSTR(birthday,6,5) = :today'); 
    294294            $q->bindParam(':today', $_today->format('m-d'), PDO::PARAM_STR, 5); 
    295295            $s = $q->execute();