Bueno vuelvo a postear la ayuda porque no se si lo entendi bien o que pero no me funciono:
Asi quedaria mi php de carga de datos:
Código PHP:
<FORM METHOD="POST" ACTION="insert_pf.php">
<table align="center" border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="75%" id="AutoNumber1" height="214">
<tr bgcolor="#CCCCCC">
<td height="19" colspan="6"><span class="style1"><font face="Verdana" size="1">
REGISTRO DE PERSONA FISICA:</font></span></td>
</tr>
<tr>
<td height="19" colspan="6"> </td>
</tr>
<tr>
<td width="25%" height="24"><font face="Verdana" size="1">Apellido</font></td>
<td width="1%" height="24"> </td>
<td width="28%" height="24"><INPUT NAME="apellido" MAXLENGTH="100" TYPE="TEXT" VALUE=""></td>
<td width="12%" height="24"><font face="Verdana" size="1">Nombre:</font></td>
<td width="1%" height="24"> </td>
<td width="33%" height="24"><INPUT NAME="nombre" MAXLENGTH="100" TYPE="TEXT" VALUE=""></td>
</tr>
<tr>
<td width="25%" height="19"><font face="Verdana" size="1">Dirección:</font></td>
<td width="1%" height="19"> </td>
<td width="28%" height="19"><INPUT NAME="direccion" MAXLENGTH="100" TYPE="TEXT" VALUE=""></td>
<td width="12%" height="19"><font face="Verdana" size="1">Documento:</font></td>
<td width="1%" height="19"> </td>
<td width="33%" height="19"><INPUT NAME="numero_doc" MAXLENGTH="100" TYPE="TEXT" VALUE=""></td>
</tr>
<tr>
<td width="25%" height="19"><font face="Verdana" size="1">Teléfono:</font></td>
<td width="1%" height="19"> </td>
<td width="28%" height="19"><INPUT NAME="telefono" MAXLENGTH="100" TYPE="TEXT" VALUE=""></td>
<td width="12%" height="19"><font face="Verdana" size="1">Celular:</font></td>
<td width="1%" height="19"> </td>
<td width="33%" height="19"><INPUT NAME="celular" MAXLENGTH="100" TYPE="TEXT" VALUE=""></td>
</tr>
<tr>
<td width="25%" height="19"><font face="Verdana" size="1">Situación Laboral:</font></td>
<td width="1%" height="19"> </td>
<td width="28%" height="19"><INPUT NAME="situacion" MAXLENGTH="100" TYPE="TEXT" VALUE=""></td>
<td width="12%" height="19"><font face="Verdana" size="1">Ciudad:</font></td>
<td width="1%" height="19"> </td>
<td width="33%" height="19"><INPUT NAME="ciudad" MAXLENGTH="100" TYPE="TEXT" VALUE=""></td>
</tr>
<tr>
<td width="25%" height="19"><font face="Verdana" size="1">Cod. Postal:</font></td>
<td width="1%" height="19"> </td>
<td width="28%" height="19"><INPUT NAME="cod_postal" MAXLENGTH="100" TYPE="TEXT" VALUE=""></td>
<td width="12%" height="19"><font face="Verdana" size="1">Mail:</font></td>
<td width="1%" height="19"> </td>
<td width="33%" height="19"><INPUT NAME="mail" MAXLENGTH="100" TYPE="TEXT" VALUE=""></td>
</tr>
<tr>
<td height="19" colspan="6"> </td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="19" colspan="6"><span class="style4">REGISTRO DEL CREDITO </span></td>
</tr>
<tr>
<td height="19" colspan="6"> </td>
</tr>
<tr>
<td width="25%" height="19"><font face="Verdana" size="1">Fecha de la Solicitud :</font></td>
<td width="1%" height="19"> </td>
<td width="28%" height="19"><INPUT NAME="fecha_solicitud" MAXLENGTH="100" TYPE="TEXT" VALUE=""></td>
<td width="12%" height="19"><font face="Verdana" size="1">Documento:</font></td>
<td width="1%" height="19"> </td>
<td width="33%" height="19"><INPUT NAME="numero_doc" MAXLENGTH="100" TYPE="TEXT" VALUE=""></td>
</tr>
<tr>
<td width="25%" height="19"><font face="Verdana" size="1">Comercio:</font></td>
<td width="1%" height="19"> </td>
<td width="28%" height="19"><INPUT NAME="id_comercio" MAXLENGTH="100" TYPE="TEXT" VALUE=""></td>
<td width="12%" height="19"><font face="Verdana" size="1">Estado:</font></td>
<td width="1%" height="19"> </td>
<td width="33%" height="19"><label>
<select name="estado">
<option>MOROSO</option>
<option>INCOBRABLE</option>
</select>
</label></td>
</tr>
<tr>
<td width="25%" height="19"><font face="Verdana" size="1">Importe del Credito :</font></td>
<td width="1%" height="19"> </td>
<td width="28%" height="19"><INPUT NAME="importe_credito" MAXLENGTH="100" TYPE="TEXT" VALUE=""></td>
<td width="12%" height="19"><font face="Verdana" size="1">Cuotas : </font></td>
<td width="1%" height="19"> </td>
<td width="33%" height="19"><INPUT NAME="cuotas_credito" MAXLENGTH="100" TYPE="TEXT" VALUE=""></td>
</tr>
<tr>
<td width="25%" height="19"><font face="Verdana" size="1">Observaciones:</font></td>
<td width="1%" height="19"> </td>
<td width="28%" height="19"><INPUT NAME="observaciones" MAXLENGTH="1000" TYPE="TEXT" VALUE=""></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="19" colspan="6"> </td>
</tr>
<tr>
<td height="19" colspan="6"> </td>
</tr>
<tr>
<td height="19" colspan="6"><div align="center">
<input name="Reset2" type="RESET" Value="Limpiar Datos">
<INPUT NAME="boton2" TYPE="SUBMIT" VALUE="Grabar Datos">
</div></td>
</tr>
</table>
</form>
Y asi quedaria mi insert:
Código PHP:
<?php
$con = mysql_connect("localhost","safsur","hobiague2475");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("safsur_com_ar_1", $con);
$sql="INSERT INTO persona_fisica (apellido,nombre,direccion,numero_doc,telefono,celular,situacion,ciudad,cod_postal,mail)
VALUES
('$_POST[apellido]','$_POST[nombre]','$_POST[direccion]','$_POST[numero_doc]','$_POST[telefono]','$_POST[celular]','$_POST[situacion]','$_POST[ciudad]','$_POST[cod_postal]','$_POST[mail]')";
if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
//echo "1 record added";
$creditos_tbl = mysql_insert_id($con);
if ($creditos_tbl){
$sql = "INSERT INTO creditos_tbl (fecha_solicitud,numero_doc,id_comercio,estado,importe_credito,cuotas_credito,observaciones) VALUES
('$_POST[fecha_solicitud]','$_POST[numero_doc]','$_POST[id_comercio]','$_POST[estado]','$_POST[importe_credito]','$_POST[cuotas_credito]','$_POST[observaciones]'')";
if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
}
mysql_close($con);
header ("Location: index.php");
?>
La cuestion es que solo me graba los primeros datos del formulario, o sea en la segunda tabla no lo hace, podrian darme una mano.
Gracias