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();
?> |
