my friend... just put the correct variables : ... VALUES ($_POST['nombreempresa'],$_POST['nombrecontacto'],$_POST['nit'],$_POST['direccion'],$_POST['ciudad'],$_POST['pais'],$_POST['telefono'],$_POST['fax'],$_POST['email1'],$_post['email2'],$_POST['$web'],$_POST['casilla'],$_POST['observaciones'])";
-----Original message----- From: Marcelo Fabiani [EMAIL PROTECTED] Date: Fri, 01 Sep 2006 15:27:19 -0300 To: Jerry Schwartz [EMAIL PROTECTED] Subject: Re: help with insert +php > Jerry Schwartz escribió: > > I don't see the form. > > > > Unless one of your included files sets the values of your variables, this > > code will insert a row of empty strings every time it executes. > > > > Regards, > > > > Jerry Schwartz > > Global Information Incorporated > > 195 Farmington Ave. > > Farmington, CT 06032 > > > > 860.674.8796 / FAX: 860.674.8341 > > > > > > -----Original Message----- > > From: Marcelo Fabiani [mailto:[EMAIL PROTECTED] > > Sent: Friday, September 01, 2006 1:06 PM > > To: mysql@lists.mysql.com > > Subject: help with insert +php > > > > > > I'm trying to insert some data to my our web database, but when Insert > > the data, it inserts all the data from my form and ads two rows with no > > data. > > > > Can someone tell me what I'm doing wrong? > > Here is the code: > > <?php > > include 'config.php'; > > include 'opendb.php'; > > $sql="INSERT INTO empresas (nombreempresa, nomcontacto, nit, > > direccion, ciudad, pais, telefonofijo, fax, email1, email2, web, > > casilla, observaciones) VALUES > > ('$nombreempresa','$nombrecontacto','$nit','$direccion','$ciudad','$pais','$ > > telefono','$fax','$email1','$email2','$web','$casilla','$observaciones')"; > > mysql_query($sql) or die ("problema con query"); > > echo "<font color='#ff9a00'> Registro Insertado!!</font><br>"; > > $sq = "SELECT * FROM empresas"; > > $result = mysql_query($sq)or die ("problema Leyendo Tabla");; > > echo "<table>"; > > echo "<tr><td>Nombre > > Empresa</td><td>Nit</td><td>Direccion</td><td>Telefono</td></tr>"; > > while ($row=mysql_fetch_row($result)){ > > echo > > "<tr><td>$row[3]</td><td>$row[4]</td><td>$row[5]</td><td>$row[8]</td></tr>"; > > } > > echo "</table>"; > > include 'closedb.php'; > > ?> > > Regards > > > > Marcelo Fabiani > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > > > > > > > Yes here Is the part of the code of the form: > > <map id="formu"><form method="post" action="insertar.php"> > <div> > <label for="nombreempresa">Nombre Empresa: * </label> > <input name="nombreempresa" id="nombreempresa" size="35" > maxlength="100" type="text"> <acronym title="Campo Nombre Empresa: 100 > carac. máx, sólo letras">?</acronym> > </div> > <div> > <label for="nombrecontacto">Nombre Contacto: * </label> > <input name="nombrecontacto" id="nombrecontacto" size="35" > maxlength="100" type="text"> <acronym title="Campo Nombre Empresa: 100 > carac. máx, sólo letras">?</acronym> > </div> > <div><input name="add" id="add" value="Registro" type="submit"> <input > name="reset" id="reset" value="Limpiar" type="reset"></div> > </form></map> > > Marcelo Fabiani > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
