Something

function getProjetIntervention(){	include('config/config.inc.php');		$MySQL = new Mysql($cfg['url'], $cfg['user'], $cfg['password'], $cfg['table'],$cfg['lang'],$cfg['verbose']);		$MySQL->executionSQL(	'SELECT n_projet, nom_projet, descrip_projet, procedure_projet, YEAR(date_debut_pr) as DebutAAAA,MONTH(date_debut_pr) as DebutMM,dayofmonth(date_debut_pr) as DebutJJ,year(date_fin_pr) as FinAAAA,MONTH(date_fin_pr) as FinMM,dayofmonth(date_fin_pr) as FinJJ,n_statut, n_intervenant' 						.' FROM projet'						.' WHERE projet.n_client = '.$this->getNum()					);			echo "\n".'<div id="content">'."\n";	echo '<h2>Listes des projets et interventions</h2>'."\n";	echo '<h3>'.htmlentities($this->getNom()).'</h3>';		echo '<br/>';		//On encode la classe Client	$ClientSerial = serialize($this);	$ClientDeSerial = urlencode($ClientSerial);		echo '<a href="index.php?action=read&cat=clients&idClient='.$ClientDeSerial.'">Informations client</a>';		if($MySQL->nombreResultat(1) > 0)		echo "<br /><br /><h3>Liste des interventions avec projet</h3><br/>";	else		echo "<br /><br /><h3>Aucun projet</h3>";		echo "\n".'<ul  type="disc">'."\n";		$nombreIntervention = 2;		//Boucle pour afficher les projets	for($i=1; $i <= $MySQL->nombreResultat(1); $i++)	{				//On récupère la première ligne de résultat		$dataProjet = $MySQL->resultat(1);				echo $dataProjet['n_projet'];				$tmpProjet = new Projet($dataProjet['n_projet'],$dataProjet['nom_projet'],$dataProjet['descrip_projet'],$dataProjet['procedure_projet'],$dataProjet['DebutJJ'],$dataProjet['DebutMM'],$dataProjet['DebutAAAA'],$dataProjet['FinJJ'],$dataProjet['FinMM'],$dataProjet['FinAAAA'],$dataProjet['n_intervenant'],$dataProjet['n_statut'],$this->getNum());					//On encode la classe Projet		$ProjetSerial = serialize($tmpProjet);		$ProjetDeSerial = urlencode($ProjetSerial);				echo '<li><h3><img src="template/skin1/'.$tmpProjet->getNumStatut().'.gif"><a href="index.php?action=read&cat=projet&numClient='.$this->getNum().'&idProjet='.$ProjetDeSerial.'">'.$tmpProjet->getNom().'</a></h3>'."\n\n";				$MySQL->executionSQL(	'SELECT n_intervention, nom_intervention, descrip_intervention, procedure_intervention, YEAR(date_debut) as DebutAAAA,MONTH(date_debut) as DebutMM,dayofmonth(date_debut) as DebutJJ,year(date_fin) as FinAAAA,MONTH(date_fin) as FinMM,dayofmonth(date_fin) as FinJJ, statut.n_statut, n_projet, n_intervenant' 							.' FROM intervention, statut'							.' WHERE intervention.n_client = '.$this->getNum()							.' AND intervention.n_statut = statut.n_statut'							.' AND n_projet = '.$dataProjet['n_projet']						);			if($MySQL->nombreResultat($nombreIntervention) > 0)				echo "\t".'<ul>'."\n";						//Boucle pour afficher les interventions par projet			for($j=1; $j <= $MySQL->nombreResultat($nombreIntervention); $j++)			{				$dataIntervention = $MySQL->resultat($nombreIntervention);								echo $dataIntervention['nom_intervention'];								$tmpIntervention = new Intervention($dataIntervention['n_intervention'], $dataIntervention['nom_intervention'], $dataIntervention['descrip_intervention'], $dataIntervention['procedure_intervention'], $dataProjet['DebutJJ'],$dataProjet['DebutMM'],$dataProjet['DebutAAAA'],$dataProjet['FinJJ'],$dataProjet['FinMM'],$dataProjet['FinAAAA'], $dataIntervention['n_statut'], $dataIntervention['n_projet'], $this->getNum(), $dataIntervention['n_intervenant']);								echo $tmpIntervention."\n";																//On encode la classe Projet				$InterventionSerial = serialize($tmpIntervention);				$InterventionDeSerial = urlencode($InterventionSerial);								echo '<li><img src="template/skin1/'.$tmpIntervention->getNumStatut().'.gif"><a href="index.php?action=read&cat=intervention&idIntervention='.$InterventionDeSerial.'">'.$tmpIntervention->getNomIntervention().'</a>'."\n";			}		if($MySQL->nombreResultat($nombreIntervention) > 0)		echo "\t".'</ul><br />'."\n";		$nombreIntervention++;	}	echo "\n".'</ul>'."\n";	echo "<br />";		$MySQLInterventionRapide = new Mysql($cfg['url'], $cfg['user'], $cfg['password'], $cfg['table'],$cfg['lang'],$cfg['verbose']);		//On effectue une sélection d'intervention concernant un client et ayant la valeur NULL dans n_projet	$MySQLInterventionRapide->executionSQL(	'SELECT *' 						.' FROM intervention, statut'						.' WHERE intervention.n_client = '.$this->getNum()						.' AND intervention.n_statut = statut.n_statut'						.' AND n_projet = 0'					);	if($MySQLInterventionRapide->nombreResultat(1) > 0)	{		echo "<h3>Liste des interventions \"rapide\"</h3>";				//On parcours toutes les interventions sans projet		for($i=1; $i <= $MySQLInterventionRapide->nombreResultat(1); $i++){		$dataInterventionRapide = $MySQLInterventionRapide->resultat(1);				$tmpInterventionRapide = new Intervention($dataInterventionRapide['n_intervention'], $dataInterventionRapide['descrip_intervention'], $dataInterventionRapide['procedure_intervention'], $dataInterventionRapide['prevision_intervention'], $dataInterventionRapide['date_debut'], $dataInterventionRapide['date_fin'], $dataInterventionRapide['n_statut'], $dataInterventionRapide['n_projet'], $this->getNum(), $dataInterventionRapide['n_intervenant']);		//On encode la classe Projet		$InterventionSerialRapide = serialize($tmpInterventionRapide);		$InterventionDeSerialRapide = urlencode($InterventionSerialRapide);				echo '<li><a href="index.php?action=read&cat=intervention&idIntervention='.$InterventionDeSerialRapide.'">'.$tmpInterventionRapide->getDescription().'</a></li>'."\n";			}			}else	{		echo "<h3>Aucune intervention \"rapide\"</h3>";	}	}