le 28/12/2006 à 13:53
ligne vide dans une liste déroulante
*** pb résolu...
// 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éné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>