Merci JORDANE ce que je veux c'est établir le répartition de N candidats enregistrés dans une table "candidats" sur M jour d'examen enregistrés dans une table "jourexamens" sachant que le nombre de candidats par jour est fixé à l'avance ( disant 100/jour ou 150/jour), je me suis coincé à la gestion de ce nombre par jour
mon code est pareille
<?PHP
$a="SELECT * FROM centreregional WHERE ins='$ins'";
$b=mysql_query($a) or die('ppppppppppppppppppppppppppppp');
$c=mysql_fetch_row($b);
$ma=$c['4'];//cadence
print" $ma<br> ";
$x="SELECT COUNT(*) FROM $ss";
$y=mysql_query($x) or die('ppppppppppppppppppppppppppppp');
$u=mysql_fetch_row($y);
$l=$u['0'];//nombre total des condidats
print" $l<br> ";
$xm="SELECT * FROM jourexamreg";
$ym=mysql_query($xm) or die('ppppppppppppppppppppppppppppp');
$zm=mysql_fetch_row($ym);
$am=$zm['2']; //le jour d'examen choisi
$va="SELECT * FROM $ss";
$vb=mysql_query($va) or die('ppppppppppppppppppppppppppppptttttttttttttttttttttttttt');
while($vc=mysql_fetch_row($vb))
{
$vd=$vc['0'];$ve=$vc['1'];$vf=$vc['2'];$vg=$vc['3'];$vh=$vc['15'];$vi=$vc['11'];$vj=$vc['12'];
print"***$vh****<br>";
$xv="SELECT * FROM gouvernerat WHERE gov='$vh'";
$yv=mysql_query($xv) or die('pppppppppppppppppppppppppppppyyyyyyyyyyyyyyyyyyyyyyyyyyyy');
$zv=mysql_fetch_row($yv);
$iv=$zv['1'];
$xx="SELECT * FROM $tt";
$yy=mysql_query($xx) or die('pppppppppppppppppppppppppppppuuuuuuuuuuuuuuuuuuuuuuuu');
$zz=mysql_fetch_row($yy);
$ab=$zz['8'];
$xm="SELECT * FROM jourexamreg";
$ym=mysql_query($xm) or die('ppppppppppppppppppppppppppppp');
$zm=mysql_fetch_row($ym);
$am=$zm['2']; //le jour d'examen choisi
$xq="SELECT COUNT(*) FROM $tt WHERE dateecrit='$am'";
$ys=mysql_query($xq) or die('pppppppppppppppppppppppppppppoooooooooooo');
$zf=mysql_fetch_row($ys);
$er=$zf['0'];
print"//////$er////////////<br><br>";
if($er<$ma)
{
// print"***$ab****<br>";
//print"***$am****<br>";
$ta="INSERT INTO $tt (N°dossier, nom, prenom, pere, cin, emp, resdos, empecrit, dateecrit) VALUES ('$vd','$ve','$vf','$vg','$vi','$vj','?????','$iv','$am')";
$yr=mysql_query($ta)or die("problem1éééééééééééééuuuuuuuuuuuuuuu");
}
else
{
$xn="SELECT * FROM jourexamreg where date!='$am'";
$yn=mysql_query($xn) or die('ppppppppppppppppppppppppppppprrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr');
$zn=mysql_fetch_row($yn);
$ao=$zn['2'];
$xu="SELECT COUNT(*) FROM $tt WHERE dateecrit='$ao'";
$yw=mysql_query($xu) or die('pppppppppppppppppppppppppppppoooooooooooo');
$zw=mysql_fetch_row($yw);
$ew=$zw['0'];
if($ew<$ma)
{
$ti="INSERT INTO $tt (N°dossier, nom, prenom, pere, cin, emp, resdos, empecrit, dateecrit) VALUES ('$vd','$ve','$vf','$vg','$vi','$vj','?????','$iv','$ao')";
$yi=mysql_query($ti)or die("problem1éééééééééééééuuuuuuuuuuuuuuu");
}
}
}
if($yr || $yi) echo"<script> alert("????? ????? ????????? ??? ?????") ;</script>";