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] Quote Link to comment 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.