orionis1

// Chargement des conditions générales du contrat choisi (2ème liste déroulante).

if($numcont != "Choix")

	{

    $req_compcg = "SELECT numcg,$db_rh.compcg.numcomp AS numcomp,machine,libcomp,desccomp";

    $req_compcg .= " FROM $db_rh.compcg,$db_rh.competence";

    $req_compcg .= " WHERE numcont = '$numcont'";    

    $req_compcg .= " AND $db_rh.compcg.numcomp = $db_rh.competence.numcomp";

    $lnk_compcg = mysql_query($req_compcg);



    while($lig_compcg = mysql_fetch_assoc($lnk_compcg))

        {    

        $numcg = $lig_compcg["numcg"];

        

        $vtp->NewSession($handle,"COMP");

        $vtp->SetVar($handle,"COMP.NUMCOMP",$lig_compcg['numcomp']);



        $libcomp = $lig_compcg["libcomp"];

        if($lig_compcg["desccomp"] != "")

            $libcomp .= " (" . $lig_compcg["desccomp"] . ")";

            

        $vtp->SetVar($handle,"COMP.LIBCOMP",$libcomp);

        

        if($numcomp == $lig_compcg['numcomp']) 

            $vtp->SetVar($handle,"COMP.SEL_NUMCOMP","selected");



        $vtp->CloseSession($handle,"COMP");

        

        if($lig_compcg["machine"] == 0)

            $machine = "Matériel : NON";

        else

            $machine = "Matériel : OUI";

        }

    

    $vtp->SetVar($handle,"COMPET.MACHINE",$machine);        

    }

// Quelle(s) zone(s) a (ont) été saisie(s)?

if($_GET["numcont"] == "") 

    $numcont = "Choix";

else 

	$numcont = $_GET["numcont"];



if($_GET["numcomp"] == "") 

    {

    $numcomp = "Choix";

    $vtp->NewSession($handle,"COMP");

    $vtp->SetVar($handle,"COMP.NUMCOMP",$numcomp);

    $vtp->CloseSession($handle,"COMP");



      $vtp->SetVar($handle,"COMPET.MACHINE"," ");

    }

else 

	$numcomp = $_GET["numcomp"];

<tr>



        <td align="left" style="background:#C1EBFF">Contrat</td>



        <td align="left" colspan="2" style="background:#D6FEC8">



            <select onchange='refresh_tableau()' name='contrat' id='contrat'>



                <option value="Choix">Choix</option>



                <!--VTP_CONTRAT-->



                <option value="{#NUMCONT}" {#SEL_CONTRAT}>{#NUMCONT}</option>



                <!--/VTP_CONTRAT-->



            </select>



        </td>



    </tr>



    <tr>



        <td align="left" style="background:#C1EBFF">Conditions g&eacute;n&eacute;rales</td>                



        <td align="left" style="background:#D6FEC8">



            <select onchange='refresh_tableau()' name='competence' id='competence'>



                <option value="Choix">Choix</option>



                <!--VTP_COMP-->



                <option value="{#NUMCOMP}" {#SEL_NUMCOMP}>{#LIBCOMP}</option>



                <!--/VTP_COMP-->



            </select>



        </td>