|
Revision 1340, 0.7 kB
(checked in by anonymous, 4 years ago)
|
Initial revision
|
- Property svn:eol-style set to
native
- Property svn:keywords set to
Author Date Id Revision
|
| Line | |
|---|
| 1 |
<?php |
|---|
| 2 |
$right_chk=9; |
|---|
| 3 |
require_once("common.php"); |
|---|
| 4 |
|
|---|
| 5 |
dolog("stat_comp_1"); |
|---|
| 6 |
|
|---|
| 7 |
include("head.php"); |
|---|
| 8 |
?> |
|---|
| 9 |
<p><a href="stat_compute.php">Retour à la liste des calculs disponibles</a></p> |
|---|
| 10 |
<p>Le <?php echo date("d/m/Y h:i:s"); ?></p> |
|---|
| 11 |
<h1>Nombre d'étudiant demandeurs par territoire : </h1> |
|---|
| 12 |
<?php |
|---|
| 13 |
|
|---|
| 14 |
$r=mq("SELECT count(u.login) AS cnt,t.territoire FROM users u INNER JOIN territoires t ON t.id=u.tid WHERE u.etusta=1 AND u.typ=0 GROUP BY t.id ORDER BY 2"); |
|---|
| 15 |
|
|---|
| 16 |
echo "<table class=\"mgt\"><tr><th>Territoire</th><th>Etudiants demandeurs</th></tr> |
|---|
| 17 |
"; |
|---|
| 18 |
while ($c=mysql_fetch_array($r)) { |
|---|
| 19 |
echo "<tr><td>".$c[territoire]."</td><td>".$c[cnt]."</td></tr> |
|---|
| 20 |
"; |
|---|
| 21 |
} |
|---|
| 22 |
echo "</table>"; |
|---|
| 23 |
|
|---|
| 24 |
include("foot.php"); |
|---|
| 25 |
?> |
|---|
