$dtmin = mktime("0", "0", "0", $month, $day, $year); // dans la base de données la date est au format unix
$list = query("SELECT * FROM database WHERE date BETWEEN '$dtmin' AND '$dtmax'"
while ($ligne = mysql_fetch_array($list,MYSQL_ASSOC)) //temps q'une occurence est trouvée
### Default Params
$param_d['calendar_id'] = 1; // Calendar ID
$param_d['calendar_columns'] = 5; // Nb of columns
$param_d['show_day'] = 1; // Show the day bar
$param_d['show_month'] = 1; // Show the month bar
$param_d['nav_link'] = 1; // Add a nav bar below
$param_d['link_after_date'] = 1; // Enable link on days after the current day
$param_d['link_on_day'] = $PHP_SELF.'?date='; // Link to put on each day
$param_d['font_face'] = 'Verdana, Arial, Helvetica'; // Default font to use
$param_d['font_size'] = 10; // Font size in px
$param_d['bg_color'] = 'designtransparent.gif';
$param_d['today_bg_color'] = 'designtransparent_bleu.gif';
$param_d['match_color'] = 'designtransparent_rouge.gif';
$param_d['match_today'] = 'designtransparent_today.gif';
$param_d['font_today_color'] = '#990000';
$param_d['font_color'] = '#000000';
$param_d['font_nav_bg_color'] = '#A9B4B3';
$param_d['font_nav_color'] = '#FFFFFF';
$param_d['font_header_color'] = '#AAAAAA';
$param_d['border_color'] = 'transparent'; //'#3f6551';
$param_d['use_img'] = 1; // Use gif for nav bar on the bottom
[/quote]
enfin modification et insertion des elements de la base dans le calendrier
[quote]
$output = '<style type="text/css">
<!--
.calendarNav'.$param['calendar_id'].' { font-family: '.$param['font_face'].'; font-size: '.($param['font_size']-1).'px; font-style: normal; background-color: '.$param['border_color'].'}
.calendarTop'.$param['calendar_id'].' { font-family: '.$param['font_face'].'; font-size: '.($param['font_size']+1).'px; font-style: normal; color: '.$param['font_header_color'].'; font-weight: bold; background-color: '.$param['border_color'].'}
.calendarToday'.$param['calendar_id'].' { font-family: '.$param['font_face'].'; font-size: '.$param['font_size'].'px; font-weight: bold; color: '.$param['font_today_color'].'; background-image: url('.$param_d['today_bg_color'].');}
.calendarDays'.$param['calendar_id'].' { font-family: '.$param['font_face'].'; font-size: '.$param['font_size'].'px; font-style: normal; color: '.$param['font_color'].'; background-image: url('.$param['bg_color'].'); text-align: center}
.calendarHeader'.$param['calendar_id'].'{ font-family: '.$param['font_face'].'; font-size: '.($param['font_size']-1).'px; background-color: '.$param['font_nav_bg_color'].'; color: '.$param['font_nav_color'].';}
.calendarTable'.$param['calendar_id'].' { background-color: '.$param['border_color'].'; border: 0px '.$param['border_color'].' solid}
.calendarMatch'.$param['calendar_id'].' { font-family: '.$param['font_face'].'; font-size: '.$param['font_size'].'px; font-style: normal; color: '.$param['font_color'].'; background-image: url('.$param['match_color'].'); text-align: center}
.MatchToday'.$param['calendar_id'].' { font-family: '.$param['font_face'].'; font-size: '.$param['font_size'].'px; font-style: normal; color: '.$param['font_color'].'; background-image: url('.$param['match_today'].'); text-align: center}
-->
</style>';
$output .= '<TABLE width="140" class="calendarTable'.$param['calendar_id'].'" cellpadding="2" cellspacing="1">'."n";
### Displaying the current month/year
//////////////////
/////////////////
### Row start
if ((($i + $first_day_pos-1) % $param['calendar_columns']) == 1 && $i != 1) {
$output .= '<TR align="center">'."n";
$int_counter = 0;
}
$color = "";
$loop_timestamp = mktime(0,0,0, $current_month, $i, $current_year);
$contenu = actuel($loop_timestamp);
if ($i == $current_day) {
if ($contenu){
$color = "MatchToday".$param['calendar_id'];
}
else {
$color = "calendarToday".$param['calendar_id'];
}
}
if ($param['link_on_day'] != '') {
if ( ($param['link_after_date'] == 0) && ($current_timestamp < $loop_timestamp) OR ($contenu == ""

) {
if ($color == ""

{$color = "calendarDays".$param['calendar_id'];}
$link = $i;
}
else {
if ($color == ""

{$color = "calendarMatch".$param['calendar_id'];}
$link = '<A href="'.$param["link_on_day"].$current_year.$current_month_2.$i_2.'" title="'.$contenu.'">'.$i.'</A>';
}
}
else {
if ($color == ""

{$color = "calendarDays".$param['calendar_id'];}
$link = $id;
}
$output .= '<TD class="'.$color.'">'.$link.'</TD>'."n";
comme par exemple ne faire appel à la bdd qu'une fois et sotcker le contenu du mois dans un tableau de variable du genre [quote] $contenu[$jour]