[tttony]

Code Updated Ok....

[theModster]

i added your edit and when i register i get this error: Error no. 1136

[tttony]

try with this.. and tell me...

PHP Code:

$conn = mysql_connect("-----","-----","-----");

$db = mysql_select_db("a3346318_users");

$username = $_POST["username"];
$password = $_POST["password"];
$email = $_POST["email"];

$sql = sprintf("INSERT INTO members2 (username, password, email) VALUES('%s','%s','%s')", $username, $password, $email);

$result = @mysql_query($sql);

if (mysql_errno() == 1062) 
{ 
    echo "The user " . $username . " exist please try again with another username"; 
} 
elseif(mysql_errno() == 0) 
{ 
   echo "Thank you for registering " . $username; 
} 
else 
{ 
   echo "Error no. " . mysql_errno() . " <br />Description: " . mysql_error(); 
} 


[theModster]

my brother you are a lifesaver! thank you man! its workin just how i wanted it 2 with my original 1/2 code i had originally lolz

[tttony]

thats good and thanks for the karma

[theModster]

i added to your karma. Thanks alot

[shikha]

Hello Buddy

If you want to remove duplicasy from your table You just have to apply the primary and unique constraint

Thanks