hola soy nuevo aqui, estoy haciendo una sistema de ventas y facturacion en php y mysql, en el cual trabajo con 7 tablas hechas en mysql, para el funcionamiento del sistema de las cuales con dos tengo problemas a la hora de insertar los datos. al darle a guardar en la base de datos hace como si guardara los datos, pero al revisar la base de datos me doy cuenta que esta vacia y ya se me estan acabando las idea, aqui dejo el codigo principal que estoy usando, espero que me puedan ayudar con esto.
factproveedor.php(de aqui se envia al archivo que lo guarda)
<form enctype="multipart/form-data" method="POST" id="form1" name="form1" >
<?php
$conexion= mysql_connect("localhost","root","");
mysql_select_db("servifrenos",$conexion);
$sql="SELECT MAX(idfact)+1 AS idfact FROM factproveedor";
$comprobar=mysql_query($sql);
if(mysql_num_rows ($comprobar) > 0)
{
$user = mysql_fetch_array($comprobar);
}
?>
?>
<div>
<div>
</div>
<div>
<label class="bleach" for="nombre">Numero de factura: </label>
<input class="sampletext3" type="text" name="idfact" maxlength="30" size="67" value="<?php echo $user["idfact"]?>" />
<label class="bleach" for="nombre">Empresa: </label>
<input class="sampletext3" type="text" name="empresa" maxlength="30" size="67" value="SERVIFRENOS LM2021.CA" />
<label class="bleach" for="nombre">Rif: </label>
<input class="sampletext3" type="text" name="rif" maxlength="30" size="67" value="RIF:J-40154425-8" />
</div>
<div>
<label class="bleach" for="nombre">Fecha: </label>
<input class="sampletext3" type="text" name="fecha" maxlength="30" size="67" value="<?php echo date("Y-m-d")?>" />
</div>
<div>
<br><label class="sao2" for="factura">Proveedor:</label></br>
</div>
<div>
<br> <label class="bleach" for="nombre">Nombre del Proveedor: </label>
<input class="sampletext" type="text" name="nombre" maxlength="30" size="67" /></br>
</div>
<div>
<label class="bleach" for="apellido">Apellido del Proveedor: </label>
<input class="sampletext" type="text" name="apellido" maxlength="30" size="67" />
</div>
<div>
<label class="bleach" for="cedula">Cedula: </label>
<input class="sampletext" type="text" name="cedula" maxlength="30" size="67" />
</div>
<div>
<label class="bleach" for="telefono">Telefono: </label>
<input class="sampletext" type="text" name="telefono" maxlength="30" size="67" />
</div>
<div>
<label class="bleach" for="descripcion">Lugar:</label>
<input class="sampletext" type="text" name="lugar" maxlength="200" size="67" />
</div>
<div>
<label class="bleach" for="Dirrecion">Dirrecion:</label>
<input class="sampletext" type="text" name="dirre" maxlength="200" size="67" />
</div>
<div>
<label class="bleach" for="Dirrecion">status:</label>
<select class="sampletext" name="status" >
<option value="zero">selecione</option>
<option value="venta">venta</option>
<option value="compra">compra</option>
<option value="devolucion">devolucion</option>
<option value="pendite">pendiente</option>
</select>
</div>
<br><label class="sao2" for="factura2">Productos:</label></br>
</div>
<div>
<br><table width="200" border="1">
<thead><tr>
<td><label class="bleach" for="producto">Producto:</label></td>
<td><label class="bleach" for="Precio">Precio:</label></td>
<td><label class="bleach" for="Cantidad">Cantidad:</label></td>
<td><label class="bleach" for="Total">Total:</label></td>
</tr></thead>
<tr>
<td> <input class="sampletext" type="text" name="mer1" id="mer1" maxlength="200" size="25" onChange="calcular();" /></td>
<td> <input class="sampletext" type="text" name="pre1" id="pre1" maxlength="200" size="25" onChange="calcular();"/></td>
<td><input class="sampletext" type="text" name="cant1" id="cant1" maxlength="200" size="25" onChange="calcular();" /></td>
<td><input class="sampletext" type="text" name="total1" id= "total1" maxlength="200" size="25" onChange="calcular();" />
</td>
</tr>
<tr>
<td><input class="sampletext" type="text" name="mer2" id="mer2" maxlength="200" size="25" onChange="calcular();" /></td>
<td> <input class="sampletext" type="text" name="pre2" maxlength="200" size="25" onChange="calcular();" /></td>
<td><input class="sampletext" type="text" name="cant2" maxlength="200" size="25" onChange="calcular();" /></td>
<td><input class="sampletext" type="text" name="total2" maxlength="200" size="25" onChange="calcular();" /></td>
</tr>
<tr>
<td> <input class="sampletext" type="text" name="mer3" id="mer3" maxlength="200" size="25" onChange="calcular();" /></td>
<td> <input class="sampletext" type="text" name="pre3" maxlength="200" size="25" onChange="calcular();" /></td>
<td><input class="sampletext" type="text" name="cant3" maxlength="200" size="25" onChange="calcular();" /></td>
<td><input class="sampletext" type="text" name="total3" maxlength="200" size="25" onChange="calcular();" /></td>
</tr>
<tr>
<td><input class="sampletext" type="text" name="mer4" id="mer4" maxlength="200" size="25" onChange="calcular();" /></td>
<td> <input class="sampletext" type="text" name="pre4" maxlength="200" size="25" onChange="calcular();"/></td>
<td><input class="sampletext" type="text" name="cant4" maxlength="200" size="25" onChange="calcular();"/></td>
<td><input class="sampletext" type="text" name="total4" maxlength="200" size="25" onChange="calcular();"/></td>
</tr>
<tr>
<td><input class="sampletext" type="text" name="mer5" id="mer5" maxlength="200" size="25" onChange="calcular();" /></td>
<td> <input class="sampletext" type="text" name="pre5" maxlength="200" size="25" onChange="calcular();"/></td>
<td><input class="sampletext" type="text" name="cant5" maxlength="200" size="25" onChange="calcular();"/></td>
<td><input class="sampletext" type="text" name="total5" maxlength="200" size="25" onChange="calcular();"/></td>
</tr>
</td>
<td><input class="sampletext" type="text" name="mer6" id="mer6" maxlength="200" size="25" onChange="calcular();" /></td>
<td> <input class="sampletext" type="text" name="pre6" maxlength="200" size="25" onChange="calcular();"/></td>
<td><input class="sampletext" type="text" name="cant6" maxlength="200" size="25" onChange="calcular();"/></td>
<td><input class="sampletext" type="text" name="total6" maxlength="200" size="25" onChange="calcular();"/></td>
</tr>
</td>
<td><input class="sampletext" type="text" name="mer7" id="mer7" maxlength="200" size="25" onChange="calcular();" /></td>
<td> <input class="sampletext" type="text" name="pre7" maxlength="200" size="25" onChange="calcular();"/></td>
<td><input class="sampletext" type="text" name="cant7" maxlength="200" size="25" onChange="calcular();"/></td>
<td><input class="sampletext" type="text" name="total7" maxlength="200" size="25" onChange="calcular();"/></td>
</tr>
</td>
<td><input class="sampletext" type="text" name="mer8" id="mer8" maxlength="200" size="25" onChange="calcular();" /></td>
<td> <input class="sampletext" type="text" name="pre8" maxlength="200" size="25" onChange="calcular();"/></td>
<td><input class="sampletext" type="text" name="cant8" maxlength="200" size="25" onChange="calcular();"/></td>
<td><input class="sampletext" type="text" name="total8" maxlength="200" size="25" onChange="calcular();"/></td>
</tr>
</td>
<td><input class="sampletext" type="text" name="mer9" id="mer9" maxlength="200" size="25" onChange="calcular();" /></td>
<td> <input class="sampletext" type="text" name="pre9" maxlength="200" size="25" onChange="calcular();"/></td>
<td><input class="sampletext" type="text" name="cant9" maxlength="200" size="25" onChange="calcular();"/></td>
<td><input class="sampletext" type="text" name="total9" maxlength="200" size="25" onChange="calcular();"/></td>
</tr>
</td>
<td><input class="sampletext" type="text" name="mer10" id="mer10" maxlength="200" size="25" onChange="calcular();" /></td>
<td> <input class="sampletext" type="text" name="pre10" maxlength="200" size="25" onChange="calcular();"/></td>
<td><input class="sampletext" type="text" name="cant10" maxlength="200" size="25" onChange="calcular();"/></td>
<td><input class="sampletext" type="text" name="total10" maxlength="200" size="25" onChange="calcular();"/></td>
</tr>
</td>
</tr>
</table></br>
<div><div><label class="bleach" for="Correo">Subtotal:</label>
<input class="sampletext" type="text" name="subtotal1" id="subtotal1" maxlength="200" size="25" value="0" onChange="calcular();" /></div>
<div><label class="bleach" for="Correo">Iva:</label>
<input class="sampletext" type="text" name="iva1" id="iva1" maxlength="200" size="25" value="0"onChange="calcular();" /></div>
<div><label class="bleach" for="Correo">Descento:</label>
<input class="sampletext" type="text" name="desc1" id="desc1" maxlength="200" size="25" value="0."onChange="calcular();" /></div>
<div><label class="bleach" for="Correo">Total a Pagar:</label>
<input class="sampletext" type="text" name="totalps" id="totalps"maxlength="200" size="25" value="0"onChange="calcular();" /></div>
</div>
</div>
<div>
<label class="bleach" for="Opciones">Opciones:</label>
<input class="btn" type="submit" value=" Nuevo" onclick = "this.form.action = 'factprovedor.php'" />
<input class="btn" type="submit" value=" guardar" onclick = "this.form.action = 'factprovedorB.php'"/>