Que tengo mal en este código que cuando le asigno un valor a un objeto text del formulario, solo me muestra el primer valor del array:
Código PHP:
$sql="SHOW COLUMNS FROM $tabla";
$result = mysql_query($sql,$link);
echo "<tr><td colspan='2' class='encabeza'>Editando $tabla</td></tr>";
$sql_editar="select * from dpswd.$tabla where id_".$tabla."='$id_'";
$result_editar=mysql_query($sql_editar,$link);
$num=mysql_num_fields($result_editar);
for ($h=0; $h<mysql_num_rows($result_editar); $h++)
{
for ($d=1;$d<$num;$d++)
{
$uno1=mysql_result($result_editar, $h, $d);
$a_editar[$d]=$uno1;
while ($row = mysql_fetch_assoc($result)) {
$campos=$row;
echo "<tr>";
echo "<td align='right' valign='top'>".$campos['Field'].": </td>";
echo "<td>";
if ( $campos['Key']==MUL ) {
$campo_foraneo = $campos['Field'];
$sql="SELECT CONCAT( referenced_table_name) AS tabla_referencia
FROM information_schema.KEY_COLUMN_USAGE
WHERE REFERENCED_TABLE_SCHEMA = 'dpswd' AND REFERENCED_TABLE_NAME IS NOT NULL AND COLUMN_NAME = '$campo_foraneo'
ORDER BY TABLE_NAME, COLUMN_NAME";
$result=mysql_query($sql,$link);
//echo $sql;
$cols=mysql_fetch_object($result);
$tabla=$cols->tabla_referencia;
$sql="select * from dpswd.$tabla";
$result=mysql_query($sql,$link);
//echo $sql;
echo "<select name='".$campos."'>";
echo "<option>- - - </option>";
while ( $select=mysql_fetch_assoc($result) ){
$select_campo=$select;
echo "<option value='".$select_campo[$campo_foraneo]."'>".$select_campo[$tabla]."</option>";
}
echo "</select>";
}elseif( $campos['Type']==longtext )
{
echo "<textarea name='".$campos['Field']."' cols='50' rows='7'></textarea>";
}else{
if ( $campos['Key']==PRI )
{
echo $id_;
}else{
echo "<input type='text' name='".$campos['Field']."' value='".$a_editar[$d]."' />";
}
}
echo "</td>";
echo "</tr>";
}
}
}