Ver Mensaje Individual
  #1 (permalink)  
Antiguo 14/02/2005, 13:24
Avatar de pekeña
pekeña
 
Fecha de Ingreso: enero-2005
Ubicación: CONCEPCION
Mensajes: 57
Antigüedad: 19 años, 2 meses
Puntos: 0
actualizar registro

tengo este codigo , queiro actualizar un registro seleccionando de un select, y que me aparezcan todos los datos que he ingresado , para actualizarlos pero no me aparece nada , que sera??

<HTML>
<HEAD>
<TITLE>Actualizar.php</TITLE>
<LINK REL="STYLESHEET" HREF="style.css" TYPE="text/css">

</HEAD>

<BODY>

<?php

include('config.php');
$link=Conectarse();

$sql="select A.di_numdi, B.di_estadodi_id,B.nomempr, B.nomtransp, A,crt_numcrt, A.mezcla, A.merc, A.codaran, A.cant_merc, A.kmeto FROM item A, emptrans B WHERE A.id = B.id AND A.id = '$valor_buscado$'";


$result=mysql_query($sql, $link);
echo '<select di="id">';

while ($row=mysql_fetch_array($result))
{echo '<option>'.$row["1"];
echo '<option>'.$row["2"];
echo '<option>'.$row["3"];
echo '<option>'.$row["4"];
echo '<option>'.$row["5"];
echo '<option>'.$row["6"];
echo '<option>'.$row["7"];
echo '<option>'.$row["8"];
echo '<option>'.$row["9"];





}
?>
</select>
<br>
ID<br>
<body topmargin="0" leftmargin="0" marginheight="0" marginwidth="0">
<table width="780" border="0" cellspacing="0" cellpadding="0">

<tr>
<td>&nbsp;</td>
</tr>
</table>
<table width="780" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>
<table width="780" border="0" cellspacing="0" cellpadding="0" height="50">
<tr>
<td>&nbsp;</td>
</tr>
<tr>
<td valign="top">&nbsp; </td>
</tr>
</table>
</td>
</tr>
</table>
<table width="780" border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="texto1" align="center"><table width="520" border="0" cellspacing="0" cellpadding="0" class="borderB">
<tr>
<td height="14" class="texto1b" bgcolor="#FFFFFF"><b><img src="images/isotipo.jpg" width="573" height="67" align="top"></b></td>
</tr>
<tr>
<td height="1" bgcolor="353648"></td>
</tr>
<tr>
<td height="4"></td>
</tr>
<tr>
<td> <table width="508" border="0" cellspacing="0" cellpadding="0" align="center" class="borderA" height="300">
<tr>
<td bgcolor="ececef"> <table border="0" cellpadding="0" cellspacing="0" width="100%" class="texto1" >
<tr>
<td valign="top" width="468"> <table border=0 cellpadding=10 cellspacing=0 bgcolor="ececef" class="texto1" width="100%">
<form method="get" action='actualizardi2.php'>
<input type=hidden name='id' value='$row[0]' >

<tr valign=top>
<td><br>
Modifique los datos de la DI<br> <br>
<br> <br>
<table class="texto1" border=0 cellpadding=5 cellspacing=0>
<tr>
<td colspan=2 height="10"></td>
</tr>
<tr>
<td width="164">Numero DI</td>
<td width="273"> <input type='hidden'name=numdi class="input">
</td>
</tr>
<tr>
<td width="164">Estado DI</td>
<td width="273"> <input type= text name=codestado class="input" value='<? $row[codestado]; ?>'
>

</td>
</tr>
<tr>
<td>Empresa Transporte</td>
<td> <input name=nomempr class="input" value='<? $row[nomempr]; ?>'>
</td>
</tr>
<tr>
<td>Transportista&nbsp;</td>
<td> <input name=nomtransp class="input" value='<? $row[nomtransp]; ?>'>
</td>
</tr>
<tr>
<td>Crt</td>
<td> <input name=numcrt class="input" value='<? $row[numcrt]; ?>'>
</td>
</tr>
<tr>
<td>Mezcla</td>
<td> <input name=mezcla class="input" value='<? $row[mezcla]; ?>'>
</td>
</tr>
<tr>
<td>Mercancia&nbsp;</td>
<td> <input name=merc class="input" value='<? $row[merc]; ?>'>
</td>
</tr>

<td>Kn</td>
<td> <input name=kneto class="input" value='<? $row[kneto]; ?>'>
</td>
</tr>
<tr>
<td>Codigo Arancelario&nbsp;</td>
<td> <input type=text name=codaran value='' class="input" value='<? $row[codaran]; ?>'>
</td>
</tr>
<tr>
<td>Cantidad Mercancia </td>
<td> <input name=cant_merc value="" class="input" value='<? $row[cant_merc]; ?>'>
</td>
</tr>
<tr>
<td colspan=2>&nbsp;</td>
</tr>


<tr>
<td align=middle colspan=2><div align="center"> <input name="image" type="image" src="images/enviar.gif" align="middle" width="58" height="11" border="0">
</div></td>
</tr>
</table></td>
</tr>
</form>
</table></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<tr>
<td height="4"></td>
</tr>
</table>
<table width="427" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="5"></td>
</tr>
</table>
<td width="20"></td>
</tr>
</table>
<table width="780" border="0" cellspacing="0" cellpadding="0">

<tr>
<td>&nbsp;</td>
</tr>
</table>

</form>
__________________
Josi-Jo :adios: saludos