Amigos ¿Como estan? En esta oportunidad los molesto para solicitarles ayuda, estoy armando un script que actualiza un registro en varias filas a la vez, en problema es que al hacer click en submit no actualiza los registros ni da error, ¿En donde está el error?
Los archivos son los siguientes:
actualiza.php
Código PHP:
<?php
$host="localhost";
$username="root";
$password="";
$db_name="sanandre_sap";
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");
$sql="select *
from sistema
where `destacado` = 'Si'
and `estado` = 'Activo'";
$result=mysql_query($sql);
$count=mysql_num_rows($result);
?>
<table width="80%" border="0" cellspacing="1" cellpadding="0">
<form name="form" method="post" action="validaredicion.php">
<tr>
<td>
<table width="80%" border="0" cellspacing="1" cellpadding="0">
<tr>
<td align="center"><strong>Id</strong></td>
<td align="center"><strong>Tipo de Inmueble</strong></td>
<td align="center"><strong>Tipo de Operacion</strong></td>
<td align="center"><strong>Barrio</strong></td>
<td align="center"><strong>Calle</strong></td>
<td align="center"><strong>Altura</strong></td>
<td align="center"><strong>Actual</strong></td>
<td align="center"><strong>Orden</strong></td>
</tr>
<?php
while($rows=mysql_fetch_array($result)){
?>
<tr>
<td align="center"><?php $id[]=$rows['id']; ?><?php echo $rows['id']; ?></td>
<td align="center"><?php echo $rows['tipoinmueble']; ?></td>
<td align="center"><?php echo $rows['tipodeoperacion']; ?></td>
<td align="center"><?php echo $rows['barrio']; ?></td>
<td align="center"><?php echo $rows['calle']; ?></td>
<td align="center"><?php echo $rows['altura']; ?></td>
<td align="center"><?php echo $rows['ordendestacado']; ?></td>
<td align="center"><select name="ordendestacado[]">
<option value='' <?php if($rows['ordendestacado'] == '') echo 'selected="selected"' ?> ></option>
<option value='1' <?php if($rows['ordendestacado'] == '1') echo 'selected="selected"' ?>>1</option>
<option value='2' <?php if($rows['ordendestacado'] == '2') echo 'selected="selected"' ?>>2</option>
<option value='3' <?php if($rows['ordendestacado'] == '3') echo 'selected="selected"' ?>>3</option>
<option value='4' <?php if($rows['ordendestacado'] == '4') echo 'selected="selected"' ?>>4</option>
<option value='5' <?php if($rows['ordendestacado'] == '5') echo 'selected="selected"' ?>>5</option>
<option value='6' <?php if($rows['ordendestacado'] == '6') echo 'selected="selected"' ?>>6</option>
<option value='7' <?php if($rows['ordendestacado'] == '7') echo 'selected="selected"' ?>>7</option>
<option value='8' <?php if($rows['ordendestacado'] == '8') echo 'selected="selected"' ?>>8</option>
<option value='9' <?php if($rows['ordendestacado'] == '9') echo 'selected="selected"' ?>>9</option>
<option value='10' <?php if($rows['ordendestacado'] == '10') echo 'selected="selected"' ?>>10</option>
<option value='11' <?php if($rows['ordendestacado'] == '11') echo 'selected="selected"' ?>>11</option>
<option value='12' <?php if($rows['ordendestacado'] == '12') echo 'selected="selected"' ?>>12</option>
<option value='13' <?php if($rows['ordendestacado'] == '13') echo 'selected="selected"' ?>>13</option>
<option value='14' <?php if($rows['ordendestacado'] == '14') echo 'selected="selected"' ?>>14</option>
<option value='15' <?php if($rows['ordendestacado'] == '15') echo 'selected="selected"' ?>>15</option>
<option value='16' <?php if($rows['ordendestacado'] == '16') echo 'selected="selected"' ?>>16</option>
<option value='17' <?php if($rows['ordendestacado'] == '17') echo 'selected="selected"' ?>>17</option>
<option value='18' <?php if($rows['ordendestacado'] == '18') echo 'selected="selected"' ?>>18</option>
<option value='19' <?php if($rows['ordendestacado'] == '19') echo 'selected="selected"' ?>>19</option>
<option value='20' <?php if($rows['ordendestacado'] == '20') echo 'selected="selected"' ?>>20</option>
<option value='21' <?php if($rows['ordendestacado'] == '21') echo 'selected="selected"' ?>>21</option>
</select></td>
</tr>
<?php
}
?>
<tr>
<td colspan="4" align="center"><input type="Submit" name="Submit" value="Submit"></td>
</tr>
</table>
</td>
</tr>
</form>
</table>
y el que procesa el query que es:
validaredicion.php
Código PHP:
<?php
$host="localhost";
$username="root";
$password="";
$db_name="sanandre_sap";
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");
if($_GET[$i]){
for($i=0;$i<$count;$i++){
$sql1="UPDATE sistema SET ordendestacado='$ordendestacado[$i]' WHERE id='$id[$i]'";
$result1=mysql_query($sql1);
}
}
if($result1){
header("location:ok.php");
}
mysql_close();
?>
Gracias a todos!