Foros del Web - Ver Mensaje Individual

calavera · #4 (**permalink**) 06/02/2006, 07:06

E MODIFICADO MI CODIGO TAL COMO ME LO MENCIONASTE Y ME FUNCIONA A LA PERFEC. MUY AGRADECIDO

Cita:

Iniciado por Seppo

El error lo tenías en "value=''.$row[" poniendo dos comillas simples...

Al hacer la segunda consulta no salís del echo de PHP... Además pisas la variable $row q ya usabas. Probá con lo siguiente.

Código PHP:

  <?php 
   include('conex.php');  
   $link=Conectarse();  
   $result=mysql_query("SELECT * FROM Equipos WHERE Id_Equipos ='$Id_Equipos'",$link); 
    if($row=mysql_fetch_row($result))  
{  
 
echo  " 
       <form name=formulario method=post action=modifica_registro.php> 
       <input type=hidden name='Id_Equipos' value='$Id_Equipos'> 
         
        <table width='617' border='0' cellpadding='0' cellspacing='0'> 
        <input type='HIDDEN' name='Id_Equipos' value='$row[0]' size='10' maxlength='10'> 
 
 <tr>  
      <td width='67' height='26'>&nbsp;</td> 
      <td width='41'>&nbsp;</td> 
      <td width='91'>&nbsp;</td> 
      <td width='38'>&nbsp;</td> 
      <td width='11'>&nbsp;</td> 
      <td width='20'>&nbsp;</td> 
      <td width='21'>&nbsp;</td> 
      <td width='41'>&nbsp;</td> 
      <td width='62'>&nbsp;</td> 
      <td width='114'>&nbsp;</td> 
      <td width='2'>&nbsp;</td> 
      <td width='17'>&nbsp;</td> 
      <td width='11'>&nbsp;</td> 
    </tr> 
     <tr>  
      <td height='29' colspan='10' valign='top'><div align='center'>  
          <table width='100%' border='1'> 
            <!--DWLayoutTable--> 
            <tr>  
              <td width='100%' height='20' valign='top' bgcolor='#99CC33'> <div align='center'><font color='#666666' size='3' face='Courier New, Courier, mono'><strong>.:<font color='#000000'>EQUIPOS</font>:.</strong></font></div></td> 
            </tr> 
            </table> 
          <font color='#666666' size='4'></font></div> 
      <td>&nbsp;</td> 
    <tr>  
      <td height='21' colspan='10' valign='top'><hr></td> 
      <td></td> 
    </tr> 
    <tr>  
      <td rowspan='20' valign='top'>&nbsp;</td> 
      <td height='18'></td> 
    </tr> 
    <tr>  
      <td height='15'></td> 
      <td></td> 
      <td></td> 
      <td width='37'></td> 
      <td width='71'></td> 
      <td></td> 
      <td></td> 
      <td></td> 
      <td></td> 
      <td></td> 
      <td></td> 
      <td></td> 
      <td></td> 
      <td></td> 
    </tr> 
    <tr>  
      <td rowspan='2' valign='top'><font size='1'>N&ordm; de Serie:</font></td> 
      <td colspan='3' rowspan='3' valign='top'><input type='text' name='N_Serie' value='$row[4]'>  
      </td> 
      <td colspan='3' rowspan='2' valign='top'><font size='1'>Fecha de Compra:</font></td> 
      <td colspan='4' rowspan='3' valign='top'> <input type='text' name='Fecha_Compra' value='$row[6]'></td> 
     
      <td></td> 
    </tr> 
    <tr>  
      <td height='3'></td> 
      <td></td> 
      <td></td> 
    </tr> 
    <tr>  
      <td height='7'></td> 
      <td></td> 
      <td></td> 
      <td></td> 
      <td></td> 
      <td></td> 
      <td></td> 
    </tr> 
    <tr>  
      <td height='15' valign='top'><font size='1'>Tipo:</font></td> 
      <td rowspan='3' valign='top'> <select name='Tipo' id='select' value='$row[1]'> 
      <option value='' >Elija&nbsp;&nbsp;&nbsp;Tipo&nbsp;&nbsp;&nbsp;&nbsp;</option>"; 
       $result=mysql_query('SELECT * FROM Tipo1',$link); 
        while($row2=mysql_fetch_array($result)) { 
        echo ('<option value=\''.$row2['Tipo'].'\'>'.$row2['Tipo'].'</option>'); 
        } 
echo "        </select></td> 
      <td></td> 
      <td></td> 
      <td colspan='3' valign='top'><font size='1'>N&ordm; de Factura:</font></td> 
      <td colspan='4' rowspan='2' valign='top'> <input type='text' name='N_Factura' value='$row[7]'></td> 
      <td></td> 
      <td></td> 
      <td></td> 
    </tr> 
    <tr>  
      <td height='7'></td> 
      <td></td> 
      <td></td> 
      <td></td> 
      <td></td> 
      <td></td> 
      <td></td> 
      <td></td> 
      <td></td> 
    </tr> 
    <tr>  
      <td height='2'></td> 
      <td></td> 
      <td></td> 
      <td colspan='3' rowspan='2' valign='top'><font size='1'>Rut del Proveedor:</font></td> 
      <td colspan='4' rowspan='4' valign='top'> <input type='text' name='Rut_Proveedor' value='$row[8]'></td> 
      <td></td> 
      <td></td> 
      <td></td> 
    </tr> 
    <tr>  
      <td rowspan='2' valign='top'><font size='1'>Marca:</font></td> 
      <td rowspan='4' valign='top'> <select name='Marca' id='Marca' value='$row[2]'> 
        </select></td> 
      <td height='13'></td> 
      <td></td> 
      <td></td> 
      <td></td> 
      <td></td> 
    </tr> 
    <tr>  
      <td height='2'></td> 
      <td></td> 
      <td></td> 
      <td></td> 
      <td></td> 
      <td></td> 
      <td></td> 
      <td></td> 
    </tr> 
    <tr>  
      <td height='5'></td> 
      <td></td> 
      <td></td> 
      <td></td> 
      <td></td> 
      <td></td> 
      <td></td> 
      <td></td> 
      <td></td> 
    </tr> 
    <tr>  
      <td rowspan='2' valign='top'><font size='1'>Modelo:</font></td> 
      <td height='4'></td> 
      <td></td> 
      <td colspan='2' rowspan='2' valign='top'><font size='1'>Rut Asignado:</font></td> 
      <td></td> 
      <td colspan='2' rowspan='3' valign='top'> <select name='Rut_Asignado' id='Rut_Asignado' value='$row[9]'> 
        </select></td> 
      <td></td> 
      <td></td> 
      <td></td> 
      <td></td> 
      <td></td> 
    </tr> 
    <tr>  
      <td colspan='3' rowspan='3' valign='top'> <select name='Modelo' id='Modelo' value='$row[3]'></td> 
      <td height='11'></td> 
      <td></td> 
      <td></td> 
      <td></td> 
      <td></td> 
      <td></td> 
    </tr> 
    <tr>  
      <td height='9'></td> 
      <td></td> 
      <td></td> 
      <td></td> 
      <td></td> 
      <td></td> 
      <td></td> 
      <td></td> 
      <td></td> 
    </tr> 
    <tr>  
      <td height='2'></td> 
      <td></td> 
      <td></td> 
      <td></td> 
      <td></td> 
      <td></td> 
      <td></td> 
      <td></td> 
      <td></td> 
      <td></td> 
      <td></td> 
    </tr> 
    <tr>  
      <td height='37'>&nbsp;</td> 
      <td></td> 
      <td></td> 
      <td></td> 
      <td></td> 
      <td></td> 
      <td></td> 
      <td></td> 
      <td></td> 
      <td></td> 
      <td></td> 
      <td></td> 
      <td></td> 
      <td>&nbsp;</td> 
    </tr> 
    <tr>  
      <td height='15' valign='top'><font size='1'>Descripci&oacute;n:</font></td> 
      <td></td> 
      <td></td> 
      <td></td> 
      <td></td> 
      <td></td> 
      <td></td> 
      <td></td> 
      <td></td> 
      <td></td> 
      <td></td> 
      <td></td> 
      <td></td> 
      <td></td> 
    </tr> 
    <tr>  
      <td height='136'></td> 
      <td colspan='7' rowspan='4' valign='top'> <textarea name='Descripcion' cols='40' rows='10' wrap='PHYSICAL'>$row[5]</textarea> 
      </td> 
      <td>&nbsp;  
      <td>&nbsp;  
      <td>&nbsp; 
      <td>&nbsp;  
      <td>&nbsp;  
      <td>&nbsp;</td> 
    </tr> 
    <tr> 
      <td height='24'></td> 
      <td colspan='2' valign='top'> <input type='submit' name='Submit' value='Modificar Datos'>  
       </table> 
       </form> 
        
";      
} 
 
?>