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 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83
| <table border="1" align="center" class="tableaux" rules=all>
<col>
<colgroup span="4"></colgroup>
<div id="dessous">
<caption>Tableau B: Recours subrogatoires exercés par la societé AAA</caption>
<thead>
<tr class="style3">
<th width="93" colspan="2" align="center" scope="colgroup" >LIBELLE</th>
<th width="93" colspan="4" align="center" scope="colgroup" >MARCHE NATIONNALE </th>
<th width="93" align="center" rowspan="2">PAYS ETRANGERS</th>
<th width="93" align="center" rowspan="2">TOTAL</th>
</tr>
<tr>
<th scope="col"></th>
<th scope="col"></th>
<th scope="col">SOCIETE A</th>
<th scope="col">SOCIETE B</th>
<th scope="col">SOCIETE C</th>
<th scope="col">SOCIETE D</th>
</tr>
</thead>
</div>
<tbody>
<?php
$etat=mysql_query("SELECT DISTINCT(libelle1),libelle2,libelle3 FROM categorie WHERE autres=1 ORDER BY ordre");
$trimestre=mysql_query("SELECT count(*)AS numero,sum( montant_encaisse)as montant
FROM recours_encaisse,compagnies
WHERE nom_compagnie_adv=nom_compagnie
GROUP BY nom_compagnie_adv");
while($trim=mysql_fetch_array($etat)){
$champs1=$trim[0];
$champs2=$trim[1];
$champs3=$trim[2];
$i=0;
$a=mysql_fetch_array($trimestre);
$ch1=$a[0];
$ch2=$a[1];
?>
<tr>
<td scope="col"><?php echo $champs1?></td>
<td scope="col"><?php echo $champs2?></td>
<td scope="col"><?php echo $ch1?></td>
<td scope="col"><?php ?></td>
<td scope="col"><?php ?></td>
<td scope="col"><?php ?></td>
<td scope="col"><?php ?></td>
<td scope="col"><?php ?></td>
</tr>
<tr valign=top>
<td scope="col"><?php ?></td>
<td scope="col"><?php echo $champs3 ?></td>
<td scope="col"><?php echo $ch2?></td>
<td scope="col"></td>
<td scope="col"></td>
<td scope="col"><?php ?></td>
<td scope="col"><?php ?></th>
<td scope="col"></td>
</tr>
</tbody>
<?php
}
mysql_free_result($trimestre);
}
?>
</table>
</form>
</div>
</div>
</body>
</html> |
Partager