COUCOU

entree dans le prgm"; $connjub=pg_connect("dbname=jubil user=jubil password=waSpJug"); if(!$connjub) { echo "Impossible d effectuer la connexion.\n"; exit; } // Interrogation de la table agendacave $today=date("Y-m-d",time()); $next=$today+7; $sqljub= "SELECT * from agendacave WHERE (substring(col_date from 1 for 10) >= '$today') and substring(col_date from 1 for 10) <= '$next') ) "; $result_jub= pg_exec($sqljub); // Calcul du nombre de lignes retournées $rowsjub= pg_numrows($result_jub); echo $rowsjub; if ((!$result_jub) || ( $rowsjub == 0)) { echo "
Vacances !
"; } // Affichage des évènements for ($j=0;$j < $rowsjub; $j++) { $Date_ev=pg_result($result_jub, $j,"col_date"); $Titre_ev=pg_result($result_jub, $j,"col_titre"); $Intervenant_ev=pg_result($result_jub, $j,"col_intervenant"); $Detail_ev=pg_result($result_jub, $j,"col_detail"); $Jour_ev=pg_result($result_jub, $j,"col_jour"); echo ""; echo $Jour_ev;echo " "; echo "
"; echo $Intervenant_ev;echo " "; echo "
"; echo $Titre_ev;echo " "; echo "
"; echo $Detail_ev;echo " "; echo "
"; } pg_close($connjub); ?>

BYE