lo tengo de la siguiente manera, por favor ayúdenme!!!
Código PHP:
include('conexion.php');
$ID= array();
$StatusF1= array();
$Comentario= array();
foreach($_POST['ID'] as $key=>$value)
$ID[]= $value;
foreach($_POST['StatusF1'] as $key=>$value)
$StatusF1[]= $value;
foreach($_POST['Comentario'] as $key=>$value)
$Comentario[]= $value;
for($i=0; $i<count($StatusF1); $i++)
{
$sSQL="Update CXPD Set Status='$StatusF1[$i]', Comentario='$Comentario[$i]' where ID='$ID[$i]'";
mysql_query($sSQL)or die('La consulta SQL contiene errores.'.mysql_error());
}
mysql_close();
Código HTML:
<form method='POST' action='update_f1.php'>
<tr>
<td><input type='text' name='ID[]' size='1' value=$row[0] readonly></td>
<td><div class='cell'> $row[1] </div></td>
<td><div class='cell'> $row[2] </div></td>
<td><div class='cell'> $row[3] </div></td>
<td><div class='cell'> $row[4] </div></td>
<td><div class='cell'> $row[5] </div></td>
<td><div class='cell'> $row[6] </div></td>
<td>
<div class='cell'>
<input name='StatusF1[]' type='checkbox' value='Aprobada' class='ck_Ap'>Aprobada
<input name='StatusF1[]' type='checkbox' value='Rechazada' class='ck_Re'>Rechazada
</div>
</td>
<td>
<select name='Comentario[]'>
<option value='".$row[7]."' selected>".$row[7]."</option>
<option value='Falta de comprobantes'>Falta de comprobantes</option>
<option value='Sin '>Sin </option>
<option value='Sin PO'>Sin PO</option>
<option value='Sin Soporte'>Sin soporte</option>
<option value='Sin XML'>Sin XML</option>
</select>
</td>
<td><div class='cell'><a href=".$row[8]." target='_blank'>Factura</a> </div></td>
<td ><div class='cell'><a href=".$row[9]." target='_blank'>PO</a> </div></td>
<td ><div class='cell'><a href=".$row[10]." target='_blank'>Soporte</a> </div></td>
<td ><div class='cell'><a href=".$row[11]." target='_blank'>xml</a> </div></td>
</tr>