First: what error are you getting? Second, make your code more readable and easier to debug:
$query = "INSERT INTO usuario (USU_USUARIO, USU_CLAVE, USU_NOMBRE, USU_EMPRESA, USU_DIRECCION, USU_TELEFONO, USU_CIUDAD, USU_DEPARTAMENTO, USU_PAIS, USU_EMAIL, USU_REPCLAVE, USU_TIPCLIENTE)". VALUES ('$Cli_usuario','$Cli_Password1','$Cli_Nombre','$Cli_Empresa', ". "'$Cli_Direccion','$Cli_Telefono','$Cli_Ciudad','$Cli_Departamento','$Cli_Pa is','$Cli_Email','$Cli_RespClave', 'M')"; print $query; //do this to ensure you are sending the command you are expecting to send $result = mysql_query($query) or die("Error: ".mysql_error()); -----Original Message----- From: Sergio Cornejo [mailto:[EMAIL PROTECTED]] Sent: Monday, March 25, 2002 2:29 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] I have been trying to introduce data in a MySQL database but I don't achieve it. Hi. I have been trying to introduce data in a MySQL database but I don't achieve it. I work with MySQL 3.23.47 for windows 98, Apache 1.3.23 for windows and PHP4. The form code: <form name="frm_Registro" method="post" action="tievir/regMay.php"> <table width="91%" border="0" name="tbl_login" bgcolor="#33CCFF"> <tr> <td width="18%" height="27"><font color="#000099" face="Verdana, Arial, Helvetica, sans-serif">Nombre:</font></td> <td height="27" colspan="2"><font face="Verdana, Arial, Helvetica, sans-serif" color="#000099"> <input type="text" name="Cli_Nombre" maxlength="50" size="50"> </font> </td> </tr> <tr> <td width="18%"><font color="#000099" face="Verdana, Arial, Helvetica, sans-serif">Empresa:</font></td> <td colspan="2"> <font color="#000099" face="Verdana, Arial, Helvetica, sans-serif"> <font size="-1"> <input type="text" name="Cli_Empresa" maxlength="50" size="50"> <br> Si no pertenece a alguna empresa coloque "Independiente"</font></font></td> </tr> <tr> <td width="18%"> <p><font color="#000099" face="Verdana, Arial, Helvetica, sans-serif">Dirección:</font></p> </td> <td colspan="2"><font color="#000099" face="Verdana, Arial, Helvetica, sans-serif"> <input type="text" name="Cli_Direccion" maxlength="60" size="60"></font></td> </tr> <tr> <td width="18%"><font color="#000099" face="Verdana, Arial, Helvetica, sans-serif">Teléfono:</font></td> <td colspan="2"><font color="#000099" face="Verdana, Arial, Helvetica, sans-serif"> <input type="text" name="Cli_Telefono" maxlength="7" size="10"> </font></td> </tr> <tr> <td width="18%"><font color="#000099" face="Verdana, Arial, Helvetica, sans-serif">Ciudad:</font></td> <td colspan="2"><font color="#000099" face="Verdana, Arial, Helvetica, sans-serif"> <input type="text" name="Cli_Ciudad" maxlength="25" size="25"> </font></td> </tr> <tr> <td width="18%"><font color="#000099" face="Verdana, Arial, Helvetica, sans-serif">Departamento:</font></td> <td colspan="2"><font color="#000099" face="Verdana, Arial, Helvetica, sans-serif"> <input type="text" name="Cli_Departamento" maxlength="25" size="25"> </font></td> </tr> <tr> <td width="18%"><font color="#000099" face="Verdana, Arial, Helvetica, sans-serif">Pais:</font></td> <td colspan="2"><font color="#000099" face="Verdana, Arial, Helvetica, sans-serif"> <input type="text" name="Cli_Pais" maxlength="25" size="25"> </font></td> </tr> <tr> <td height="19" width="18%"><font color="#000099" face="Verdana, Arial, Helvetica, sans-serif">e-mail:</font></td> <td height="19" colspan="2"><font color="#000099" face="Verdana, Arial, Helvetica, sans-serif"> <input type="text" name="Cli_Email" maxlength="60" size="60"> </font></td> </tr> <tr> <td height="19" width="18%"><font color="#000099" face="Verdana, Arial, Helvetica, sans-serif">Usuario:</font></td> <td height="19" width="16%"><font color="#000099" face="Verdana, Arial, Helvetica, sans-serif"> <input type="text" name="Cli_Usuario" maxlength="15" size="17"> </font></td> <td height="19" width="66%"><font color="#000099" face="Verdana, Arial, Helvetica, sans-serif" size="-1">Debe ser de mínimo 8 y máximo 15 caracteres. Solo acepta caracteres entre la A..Z y números del 0..9.</font></td> </tr> <tr> <td height="19" width="18%"><font color="#000099" face="Verdana, Arial, Helvetica, sans-serif">Password:</font></td> <td height="19"><font color="#000099" face="Verdana, Arial, Helvetica, sans-serif"> <input type="password" name="Cli_Password1" maxlength="8" size="10"> </font></td> <td height="19"><font color="#000099" face="Verdana, Arial, Helvetica, sans-serif" size="-1">Debe ser de mínimo 5 y máximo 8 caracteres. Solo acepta caracteres entre la A..Z y números del 0..9.</font></td> </tr> <tr> <td height="19" width="18%"> <p><font color="#000099" face="Verdana, Arial, Helvetica, sans-serif">Confirmación<br> del Password:</font></p> </td> <td height="19"><font color="#000099" face="Verdana, Arial, Helvetica, sans-serif"> <input type="password" name="Cli_Password2" maxlength="8" size="10"> </font></td> <td height="19"><font color="#000099" face="Verdana, Arial, Helvetica, sans-serif" size="-1">Vuelva a digitar el password exactamente igual que el anterior.</font></td> </tr> <tr> <td height="18" width="18%"><font color="#000099" face="Verdana, Arial, Helvetica, sans-serif">Respuesta Clave:</font></td> <td height="18" colspan="2"><font color="#000099" face="Verdana, Arial, Helvetica, sans-serif"> <input type="text" name="Cli_RespClave" maxlength="60" size="60"> <br> <font size="-1">Esta frase se le pedirá en caso de que olvide su password.</font></font></td> </tr> </table> <div align="center"><br> <input type="submit" name="btn_enviar" value="Enviar"> <input type="reset" name="btn_resetF" value="Borrar Formulario"> </div> </form> and the regMay.PHP code <html> <body> <? $link = mysql_connect("localhost", "indicol","159753"); mysql_select_db("telcellco", $link); $result=mysql_query("SELECT USU_USUARIO,USU_NOMBRE FROM USUARIO WHERE USU_USUARIO=$Cli_Usuario"); $existe=mysql_num_rows($result); if ($existe!=0) { if ($Cli_Nombre==mysql_result($result, 0, "USU_NOMBRE")) { fopen("../Cliexistente.htm") } else { fopen("../usuexistenteM.htm") } } else { if (mysql_query("INSERT INTO usuario (USU_USUARIO, USU_CLAVE, USU_NOMBRE, USU_EMPRESA, USU_DIRECCION, USU_TELEFONO, USU_CIUDAD, USU_DEPARTAMENTO, USU_PAIS, USU_EMAIL, USU_REPCLAVE, USU_TIPCLIENTE) VALUES ('$Cli_usuario','$Cli_Password1','$Cli_Nombre','$Cli_Empresa', '$Cli_Direccion','$Cli_Telefono','$Cli_Ciudad','$Cli_Departamento',' $Cli_Pais','$Cli_Email','$Cli_RespClave', 'M')",$link) or die("Couldn't insert data."); { fopen ("../respureg.htm") } else { fopen ("../ErrordesconocidoM.htm") } }; ?> </body> </html> I really give up. Would you be able to help me? Thank you Sergio Cornejo -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php