Parse Error Cannot find

[madaengel]

Can you all help? The script states that there is an error on line 40 and line 40 is where I end my php. I've tried adding another } but that doesn't work. Can someone take a look? Thanks

	<?php
	include("settings.inc"); 
	/* Must enter username and password */
	if($Username == '') {
	print("Please enter a username");
	}
	elseif ($Password == '') {
	print("Please enter a password");
	}
	else {
	/* See if username exists in database, because we don't want duplicates */
	/* Define Username from Login Form */
 	$Username = $_POST['Username'];
	/* Query Database */
	mysql_select_db("Secure", $connection);
 	$query1 = "SELECT Username FROM Usersettings WHERE Username='$Username'";
 	$result1 = mysql_query($query1)  or die("ERROR");
 	$username_check = mysql_num_rows($result1);
 	/* If that username exists, advise user to select another username */
 	if($username_check > 0){
 		echo "We apologize, but the username you have selected has already been used by another member in our database. Please choose a different Username.<br><br>";
 		unset($username);
 				}
		}

/* If no duplicate usernames, continue on with inserting into database */
mysql_select_db("Secure", $connection);
$query2 = "INSERT INTO Usersettings (Username, Password) VALUES ('$Username', '$Password')";
$result = mysql_query($query2) or die("ERROR");
print("<script> location.href='index.php?Msg=User succesfully added' </script>"};
?>

[sgoku01]

Maybe you get the error, because you're allways updating the database.
This is your script structure:

<?php
if($Username == '') 
{
}
elseif ($Password == '') 
{
}
else 
{
   if($username_check > 0)
   {
   }
}
?>

'
After you've checked if the username is still available, you close the 'else' and updat the database.

I think it has to be something like this:

<?php
include("settings.inc"); 
if($Username == '') 
{
    print("Please enter a username");
}
elseif ($Password == '') 
{
    print("Please enter a password");
}
else 
{
     $Username = $_POST['Username'];

 mysql_select_db("Secure", $connection);
 $query1 = "SELECT Username FROM Usersettings WHERE Username='$Username'";
 $result1 = mysql_query($query1)  or die("ERROR");
 $username_check = mysql_num_rows($result1);

 	if($username_check > 0)
 	{
 	echo "We apologize, but the username you have selected has already been used by another member in our database. Please choose a different Username.<br><br>";
 	unset($username);
 	}

 mysql_select_db("Secure", $connection);
 $query2 = "INSERT INTO Usersettings (Username, Password)      VALUES ('$Username', '$Password')";
 $result = mysql_query($query2) or die("ERROR");
 print("<script> location.href='index.php?Msg=User succesfully      added' </script>"};
}
?>

[madaengel]

Thanks for your help, but that will allow the username to be entered more than once. I tried adding and exit before the insert script, but if I do that it isn't inserted at all. I'm stumped.

[sgoku01]

and this??

<?php
include("settings.inc"); 

if($Username == '') 
echo "Please enter a username";
elseif ($Password == '') 
echo "Please enter a password";
else 
{
$Username = $_POST['Username'];

mysql_select_db("Secure", $connection);
$query1 = "SELECT Username FROM Usersettings WHERE Username='$Username'";
$result1 = mysql_query($query1)  or die("ERROR");
$username_check = mysql_num_rows($result1);

   if($username_check > 0)
   {
   echo "We apologize, but the username you have selected has already been used by another member in our database. Please choose a different Username.<br><br>";
   unset($username);
   }
   else
   {     

   mysql_select_db("Secure", $connection);
   $query2 = "INSERT INTO Usersettings (Username, Password) VALUES ('$Username', '$Password')";
   $result = mysql_query($query2) or die("ERROR");
   print("<script> location.href='index.php?Msg=User succesfully added' </script>"};
   }
}

?>

This will only insert a username when it's not in the database.

[madaengel]

Thank you so much! It worked. Whooo!