For our local scouting group it seemed nice to write a birthday script which displays for every member on the day of his/her birthday the name and age on our homepage.

Something like "We wish XXX a happy # anniversary!'

To accomplish this I wrote a php script which gets the data of our members from a mysql db and shows the messages on the right day on our website. In the meantime also an automatic mail will be send to the person with some sort of 'personal' message.

database connection (db_connectPear.php)

< ?php
$dsn = array(
 'phptype' => 'mysql',
 'username' => 'DBUSERNAME' …