Tengo un serio problema y queria saber si alguno de uds me puede ayudar, miren les cuento, un inspector puede rechazar 3 veces una inspeccion.
Y la fecha me los tira aca f_fec_dig2, fijarse que hay 2 fechas mas de inspecciones f_fec_dig22 y f_fec_dig222, mi pregunta es la siguiente.
Cuando guardo me guarda la fecha de la primera inspeccion, y si rechaza de nuevo¿?, como hago para que me guarde en la base de datos la siguiente f_fec_dig22?. y despues la siguiente?.
Se me entiende?, muchas gracias por su ayuda, aca les mando el SQL con el q guardo.
Código PHP:
<table border=0 width="100%">
<tr>
<td width="2%"><span class="boxtext"><? echo lg_vIdFolio; ?> </span></td>
<td width="21%"><span class="boxtext">
<input type="text" readonly name="f_folio" size=10 maxlength=11 value="<? echo $f_folio; ?>">
</span></td>
<td width="18%"><span class="boxtext">Hora </span></td>
<td width="2%"> </td>
<td colspan="2"><div align="left"><span class="boxtext">Fecha y hora de inspecciones</span></div></td>
</tr>
<tr>
<td><span class="boxtext"><? echo Contratista; ?> </span></td>
<td><span class="boxtext">
<input type="text" readonly name="f_fdig_dd" size=2 maxlength=2 value="<? echo $f_fdig_dd; ?>">
/
<input type="text" readonly name="f_fdig_mm" size=2 maxlength=2 value="<? echo $f_fdig_mm; ?>">
/
<input type="text" readonly name="f_fdig_aa" size=4 maxlength=4 value="<? echo $f_fdig_aa; ?>">
</span></td>
<td><span class="boxtext">
<input type="text" readonly name="f_hora" size=5 maxlength=5 value="<? echo $f_hora; ?>">
</span></td>
<td><span class="boxtext">1°</span></td>
<td width="23%"><div align="left"><span class="boxtext">
<input type="text" readonly name="f_ni_dd2" size=2 maxlength=2 value="<? echo $f_ni_dd2; ?>">
/
<input type="text" readonly name="f_ni_mm2" size=2 maxlength=2 value="<? echo $f_ni_mm2; ?>">
/
<input type="text" readonly name="f_ni_aa2" size=4 maxlength=4 value="<? echo $f_ni_aa2; ?>">
</span></div></td>
<td width="34%"><span class="boxtext">
<input type="text" readonly name="f_hora2" size=5 maxlength=4 value="<? echo $f_hora2; ?>">
</span></td>
</tr>
<tr>
<td><span class="boxtext"><? echo E. Mandante; ?> </span></td>
<td><span class="boxtext">
<input type="text" readonly name="f_fdig_dd1" size=2 maxlength=2 value="<? echo $f_fdig_dd1; ?>">
/
<input type="text" readonly name="f_fdig_mm1" size=2 maxlength=2 value="<? echo $f_fdig_mm1; ?>">
/
<input type="text" readonly name="f_fdig_aa1" size=4 maxlength=4 value="<? echo $f_fdig_aa1; ?>">
</span></td>
<td><span class="boxtext">
<input type="text" readonly name="f_hora1" size=5 maxlength=4 value="<? echo $f_hora1; ?>">
</span></td>
<td><span class="boxtext">2°</span></td>
<td><span class="boxtext">
<input type="text" readonly name="f_ni_dd22" size=2 maxlength=2 value="<? echo $f_ni_dd22; ?>">
/
<input type="text" readonly name="f_ni_mm22" size=2 maxlength=2 value="<? echo $f_ni_mm22; ?>">
/
<input type="text" readonly name="f_ni_aa22" size=4 maxlength=4 value="<? echo $f_ni_aa22; ?>">
</span></td>
<td><span class="boxtext">
<input type="text" readonly name="f_hora22" size=5 maxlength=4 value="<? echo $f_hora22; ?>">
</span></td>
</tr>
<tr>
<td> <span class="boxtext"><? echo Administrador; ?> </span> </td>
<td><span class="boxtext">
<input type="text" readonly name="f_fdig_dd4" size=2 maxlength=2 value="<? echo $f_fdig_dd4; ?>">
/
<input type="text" readonly name="f_fdig_mm4" size=2 maxlength=2 value="<? echo $f_fdig_mm4; ?>">
/
<input type="text" readonly name="f_fdig_aa4" size=4 maxlength=4 value="<? echo $f_fdig_aa4; ?>">
</span></td>
<td><span class="boxtext">
<input type="text" readonly name="f_hora4" size=5 maxlength=4 value="<? echo $f_hora4; ?>">
</span></td>
<td><span class="boxtext">3°</span></td>
<td><span class="boxtext">
<input type="text" readonly name="f_ni_dd222" size=2 maxlength=2 value="<? echo $f_ni_dd222; ?>">
/
<input type="text" readonly name="f_ni_mm222" size=2 maxlength=2 value="<? echo $f_ni_mm222; ?>">
/
<input type="text" readonly name="f_ni_aa222" size=4 maxlength=4 value="<? echo $f_ni_aa222; ?>">
</span></td>
<td><span class="boxtext">
<input type="text" readonly name="f_hora222" size=5 maxlength=4 value="<? echo $f_hora222; ?>">
</span></td>
</tr>
<tr>
<td> <span class="boxtext"> </span> </td>
<td><span class="boxtext">
</span></td>
<td><span class="boxtext">
</span></td>
<td> </td>
<td><span class="boxtext">
</span></td>
<td><span class="boxtext">
</span></td>
</tr>
</table>
SQL
Código PHP:
$upd_sql = "UPDATE am_inspeccion SET ins_fecing2='$f_fec_dig2',ins_fecing22='$f_fec_dig22',ins_fecing222='$f_fec_dig222',ins_hora='$f_hora',ins_estado='$f_codest',ins_nomemp='$f_solicitx',ins_nomcon='$f_contacto',ins_mailcon='$f_mailcon',ins_fonocon='$f_foncon',ins_unica='$f_unica',ins_observ='$f_observ',"
."ins_inspec='$f_inspector',ins_autor='$f_nomm',ins_proyecto='$f_proyecto'";
$upd_sql .= "WHERE ins_folio='$f_folio'";