Why are doing your form in PHP format?
It just makes it much easier to do it in HTML.
I also don't really understand why you put form values in "$username".
But this is what I would have done
<?
if(isset($_POST['Submit']))
{
if ($_POST['username'] == "" or $_POST['password'] == "" )
{
echo "Please complete Username and Password";
}
else
{
$self = $_SERVER['PHP_SELF'];
$username = $_POST['username'];
$password = md5($_POST[password]); //password encryption
$mysql_host="localhost";
$mysql_user="nikon";
$mysql_pass="lol";
$mysql_dbname="nutrition_db";
$conn = @mysql_connect( "localhost", "nikon", "lol" )
or die("Could not connect to MySQL");
$db = @mysql_select_db( "nutrition_db", $conn )
or die("Could not select database");
$sql = "insert into users (username, password) values ('$username', '$password')";
$result = @mysql_query( $sql, $conn )
or die("Could not execute query");
if($result)
{
echo( "New user $username added" );
}
}
}
?>
Please enter all new user details...
<form action="<? $self ?>"method="post">
Username:<input type="text" name="username" value="">
<br>
Password:
<input type="text" names="password" value="">
<br>
<input type="submit" value="Submit" name="Submit">
</form>
