1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48
|
$sql='select count (stat) as nbre, code from table1 inner join table2 on table1 .indice=table2 .indice where stat in (1,2)
group by code order by code ';
$sql1='select count (stat) as traite , code from table1 inner join table2 on table1.indice=table2.indice where statin (1,2,3,5) group by code order by code';
// l'envoie la requête
$req = mssql_query($sql) or die('Erreur SQL !<br />'.$sql.'<br />'.mssql_error());
$req2= mssql_query($sql1) or die('Erreur SQL !<br />'.$sql1.'<br />'.mssql_error());
// la boucle qui va faire un tour pour chaque enregistrement
//----------------------------------------------------------
echo '<table border=1>';
echo '<tr><td>Code </td><td>Nombre Fiches</td><td>Argu</td><td>Pourcentage %</td></tr>';
while($data = mssql_fetch_assoc($req))
{
while($rst = mssql_fetch_assoc($req2))
{
echo '<tr>';
echo '<td>'.$rst['code'].'</td>';
echo '<td>'.$data['nbre'].'</td>';
echo '<td>'.$rst['traite'].'</td>';
echo '<td>'.round((($data['nbre']/$rst['traite'])*100), 2).' % </td>';
}
echo '</tr>';
echo '</table>';
}
// fermeture de la connexion à mssql
mssql_close();
?> |
Partager