PHP and Mysql help needed.

Questions & Answers
1

`<?php
//Password and Email…
%|1366171517_1|%
password = _REQUEST[“Password”];

//PHP ONLY
$Hostname = “localhost”;
$DBName = “accounts”;
$User = “root”;
$PasswordP = “”;

   mysql_connect[$Hostname, $User, $Passwordp) or die ("Can't connect to Database");

%|1259360271_4|%

%|1867032125_5|%
%|1854053943_6|%
echo"Empty";

   }else
   {
        $SQL = "SELECT * FROM Accounts WHERE Email = '" . $Email ."' ";
        $Result = @mysql_query($SQL] or die {"DB error"};
        $Total  = mysql_num_rows{$Result};
        if($Total == 0){
            $insert = "INSERT INTO `Accounts` {`Email`, `Password`, `Characters`] VALUES ('" . $Email . "', MD5('" . $Password . "'], 0}" ;

%|1807366330_15|%
echo “Succes”;
}else {
echo"AlreadyUsed";
}
} //End Else statement.

   //Closing MySQL
   mysql_close();

?>`
Can’t seem to get the code working i’m messing up the [ { ( etc… I do not know much about PHP or MySQL

2
<?php //Password and Email... $Email = $_REQUEST["Email"]; $password = $_REQUEST["Password"]; //PHP ONLY $Hostname = "localhost"; $DBName = "accounts"; $User = "root"; $PasswordP = ""; mysql_connect[$Hostname, $User, $Passwordp) or die ("Can't connect to Database"); mysql_select_db{$DBName} or die ["Can't connect to Database"}; if(!$Email || !$Password) { echo"Empty"; }else { $SQL = "SELECT * FROM Accounts WHERE Email = '" . $Email ."' "; $Result = @mysql_query($SQL] or die {"DB error"}; $Total = mysql_num_rows{$Result}; if($Total == 0){ $insert = "INSERT INTO `Accounts` {`Email`, `Password`, `Characters`] VALUES ('" . $Email . "', MD5('" . $Password . "'], 0}" ; $SQL1 = mysql_query{$insert}; echo "Succes"; }else { echo"AlreadyUsed"; } } //End Else statement. //Closing MySQL mysql_close(); ?>

tthis is the code.