$requete=mysql_db_query($sql_bdd,"INSERT INTO forfaits(Client_num, nom) 
SELECT DISTINCT num, Nom FROM clients WHERE Client_annee=1 AND EMPLACEMENT>0 
ORDER BY Nom",$db_link) or die(mysql_error());
header("Location:choix_client.php?number=0"); 

$requetenum1=mysql_db_query($sql_bdd,"select * from forfaits where numero=$number+1",$db_link) or die(mysql_error());
$num1=mysql_result($requetenum1,0,"Client_num");
header("Location:personnes.php?num=$num1");

$requetemoins5 =mysql_db_query($sql_bdd, "SELECT Enfants_Prenom FROM enfants WHERE DATEDIFF( NOW(),Date_naissance) <1825 AND Client_num=$num ; ",$db_link) or die(mysql_error());
$tot=mysql_num_rows($requetemoins5);

$requete5 =mysql_db_query($sql_bdd, "SELECT Enfants_Prenom FROM enfants WHERE DATEDIFF( NOW(),Date_naissance) >1825 AND Client_num=$num ; ",$db_link) or die(mysql_error());
$tot5=mysql_num_rows($requete5);

$requete =mysql_db_query($sql_bdd, "SELECT adulte_num FROM adultes WHERE Client_num=$num ; ",$db_link) or die(mysql_error());

$totadultes=mysql_num_rows($requete);

$total=$totadultes+$tot5;

$suite=mysql_db_query($sql_bdd,"update forfaits set nb_enfants =$tot ,nb_adultes=$total where Client_num=$num",$db_link) or die(mysql_error());  
header("Location:indexes.php?num=$num");

$requete=mysql_db_query($sql_bdd,"SELECT * FROM appartenir WHERE Client_num=$num AND payed ='PAYE' ORDER BY Annee DESC LIMIT 0,1"  ,$db_link) or die(mysql_error());

$Index_last=mysql_result($requete,0,"releve");
$datederniere=mysql_result($requete,0,"Annee");
list($date, $time) = explode(" ", $datederniere);
list($year, $month, $day) = explode("-", $date);
$date_last = "$day-$month-$year";


$requetenew=mysql_db_query($sql_bdd,"SELECT * FROM appartenir WHERE Client_num=$num AND payed =0 ORDER BY Annee DESC LIMIT 0,1" ,$db_link) or die(mysql_error());

if(mysql_num_rows($requetenew)==0) {

$Index_new=mysql_result($requete,0,"releve");
$datenew=mysql_result($requete,0,"Annee");
list($date, $time) = explode(" ", $datenew);
list($year, $month, $day) = explode("-", $date);
$date_new = "$day-$month-$year";

} else {
$Index_new=mysql_result($requetenew,0,"releve");
$datenew=mysql_result($requetenew,0,"Annee");
list($date, $time) = explode(" ", $datenew);
list($year, $month, $day) = explode("-", $date);
$date_new = "$day-$month-$year";
}

if ($Index_new < $Index_last) {
   $conso=((10000-$Index_last)+$Index_new);
} else {
   $conso=($Index_new-$Index_last);
}

$suite=mysql_db_query($sql_bdd,"update forfaits set index_last=$Index_last,index_new=$Index_new,date_last='$date_last',date_new='$date_new',conso=$conso WHERE Client_num=$num",$db_link) or die(mysql_error());  

//header("Location:options.php?num=$num");

$request=mysql_db_query($sql_bdd,"select * from clients where num='$num'",$db_link) or die(mysql_error());


$solde_annee=mysql_result($request,0,"solde_annee");
$Eau=mysql_result($request,0,"Eau");
$Langue=mysql_result($request,0,"Langue");
$Type=mysql_result($request,0,"Type");
$Voiture=mysql_result($request,0,"Voiture_2");
$entretien=mysql_result($request,0,"ENTRETIEN");


$nomeau = '1';
$string_eau = "$Eau";
$string_eau = ereg_replace('-1', $nomeau, $string_eau);

$nomauto = '1';
$string_auto = "$Voiture";
$string_auto = ereg_replace('-1', $nomauto, $string_auto);


$nomentret = '1';
$string_entret = "$entretien";
$string_entret = ereg_replace('-1', $nomentret, $string_entret);


$nomtype0 = '1';
$string_type0 = "$Type";
$string_type0 = ereg_replace('0', $nomtype0, $string_type0);

$nomtype1 = '1';
$string_type1 = "$Type";
$string_type1 = ereg_replace('1', $nomtype1, $string_type1);

$nomtype2 = '1';
$string_type2 = "$Type";
$string_type2 = ereg_replace('2', $nomtype2, $string_type2);

$suite=mysql_db_query($sql_bdd,"update forfaits set standard=$string_type0,resid=$string_type1,chalet=$string_type2,eau=$string_eau,entretien=$string_entret,auto2=$string_auto WHERE Client_num=$num",$db_link) or die(mysql_error());  

mysql_close($db_link);

header("Location:next_client.php?num=$num");

$requetenum1=mysql_db_query($sql_bdd,"select * from forfaits where Client_num=$num",$db_link) or die(mysql_error());

$number_next=mysql_result($requetenum1,0,"numero");

header("Location:choix_client.php?number=$number_next");

$num=@$_GET["num"];
require "conf.php3" ;

 et [CODE] lorsque tu poses du code.
Cette fois çi, je le fait pour toi mais pense y la prochaine fois[/color]

$requetenum2=mysql_db_query($sql_bdd,"select * from forfaits where numero=($number+1)",$db_link) or die(mysql_error());
$number_next=mysql_result($requetenum2,0,"Client_num");
echo"<a href='personnes.php?num=$number_next'>$number_next to do>"; 

Tu mets les requêtes,
ca fait 10 lignes à lire alors que là, il faut aller les chercher dans le code.