Benaravo Posted January 16, 2007 Share Posted January 16, 2007 Hello,I'm currently in the process of attempting my first MySQL/PHP script.. It's going to be some kind of logon script.. Protect content etc. I'm currently having problems with the script to add users to a database... I'm getting the error 'Duplicate entry '' for key 2'As far as I can make out, does the '' imply that no data is being input from the form? I've tried to fix, but can't get my head around it properly!Thanks for your help!I have the following SQL structure...ID < Primary Key (Auto Increment)User < UniquePasswordNameAdminIt may well be a problem with the Syntax with the script... Might aswell add it anyway.[code]<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /><title>Untitled Document</title></head><body><?php$usr = $_POST['user'];$pwd = $_POST['pass'];$name = $_POST['name'];$admin = $_POST['admin'];$conn= @mysql_connect( "localhost","user","password" )or die( "Error, could not connect to MySQL" );$rs = @mysql_select_db( "ben_login", $conn )or die( mysql_error() );$sql = "insert into forum (username,password,`name`,admin) values('$usr','$pwd','$name','$admin')";$rs = mysql_query( $sql, $conn )or die(mysql_error());if( $rs ){echo( "Record Added" );}else{echo('Error with MySQL Connection');}?></body></html>[/code] Link to comment https://forums.phpfreaks.com/topic/34345-new-to-mysql-duplicate-entry-for-key-2/ Share on other sites More sharing options...
Barand Posted January 16, 2007 Share Posted January 16, 2007 Looks like it added a record with a blank username and then attempted to add a second.Check input and only insert if values exist. Link to comment https://forums.phpfreaks.com/topic/34345-new-to-mysql-duplicate-entry-for-key-2/#findComment-161595 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.