affichage php avec count group by

$sqlheure="SELECT e.Immatricule, COUNT( e.Immatricule ) AS nbPoint, e.dateexacte, e.datepointage AS entree, s.datepointage AS Sortie, TIMEDIFF( s.datepointage, e.datepointage ) AS Duree
FROM pointage e
INNER JOIN pointage s ON e.Immatricule = s.Immatricule
AND e.dateExacte = s.dateexacte
AND s.typepointage = 'SORTIE'
WHERE e.typepointage = 'ENTREE'
AND e.datepointage
BETWEEN '2011-11-07 00:00:00'
AND '2011-11-12 23:59:59'
GROUP BY e.Immatricule, e.dateexacte
ORDER BY e.immatricule, e.datepointage ASC";
				//$sqldate="SELECT DATEDIFF('".$deb."','".$fin."')";
				$sqldate="SELECT DATEDIFF('2011-11-12 23:59:59','2011-11-07 00:00:00')";
				$reqdate=mysql_query($sqldate);
				echo 'requete est: '.$reqdate;
							
				echo '<th>Immatricule</th>';
				$i=0;
				while($i<=$reqdate){
					
					echo'<th>'.$i.'</th>';
					//$datedebut=$datedebut+1;
					$i++;
				}
			?>
				<th>Total Heure</th><th>HSupp 30%</th><th>HSupp 50%</th>
			</tr>
			<?php 
			$affheure=mysql_query($sqlheure);
			$i=0;
				while($dataheure=mysql_fetch_array($affheure)){
				
			?>	
					<tr>
						<td><?php  echo $dataheure['Immatricule']; ?> </td>
						<?php
							$i=0;
							while($i<=$reqdate){
							$andro=$dataheure['entree'];
								$heure=$dataheure['Duree'];
								echo '<td>'.$heure.'</td>';
								$andro=$andro+1;
								$i++;
							}
						?>  
					</tr>
			<?php
				}