select *, count (ID) group by ID

$req = "SELECT *, COUNT(*) as NB  FROM f1media WHERE 1=1"; 
if(!empty($_POST['nom_fichier']))
{
if($_POST['nom_fichier'] == '*')
$req .= " AND nom_fichier NOT LIKE  '".$_POST['nom_fichier']."' ";
else
$req .= " AND nom_fichier LIKE '%".$_POST['nom_fichier']."%' ";
}

$req.= "GROUP BY ID";
$result = mysql_query($req)
            or die ("Couldn't execute query.");
$donnee=mysql_fetch_array($result) ;
$numRec = $donnee['NB'];

$req = "SELECT ID,  COUNT(*)  as NB FROM f1media WHERE 1=1"
..
$req.= "GROUP BY ID";

$req = "SELECT *,  COUNT(*)  as NB FROM f1media WHERE 1=1"; 

select rue, count(*) as nb, year(dateconstruction) as annee_construction
from dbo.Adresse
group by rue ,year(dateconstruction)