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
| $result = mysql_query("SELECT * FROM $T_factur WHERE SECTION_REEL=''");
$n=1;
$tocheck= array();
$o=0;
while ($row = mysql_fetch_object($result))
{
$nomprenom=$row->NomPrenom;
$tocheck[$n]=$nomprenom;
$n=$n+1;
}
$result = array_unique($tocheck);
$tocheck_unique=(array_values($result));
sort($tocheck_unique);
While (list($a,$achecker)= each ($tocheck_unique))
{
$res = mysql_query("SELECT * FROM $T_effectif WHERE NomPrenom = '$achecker'");
$row = mysql_fetch_object($res);
If (!$row)
{
$res = mysql_query("SELECT * FROM $T_factur WHERE NomPrenom = '$achecker'");
$row = mysql_fetch_object($res);
$nom=$row->NOM;
$prenom=$row->PRENOM;
$nomprenom1=$nom." ".$prenom;
if($color)
{
$color_td = $color_1;
$color = false;
}
else
{
$color_td = $color_2;
$color = true;
}
$o=$o+1;
echo "<tr bgcolor=\"#".$color_td."\">\n";
echo "<td>$nomprenom1</td>";
}
} |
