[php + mysql] Need help with an error.

Error:

Code:

---

Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/a3958996/public_html/insertLogin.php on line 12

---

could you try to explain whats wrong
I am trying to make some kind of a login system but i dont want to look at yours so i wanna try to make my own to practice at my new php skillz :D

my code:

Code:

---

<?php
$con = mysql_connect(SOMETHING I WONT LET YOU SEE);
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("SOMETHING MORE", $con);


$result = mysql_query("SELECT Password FROM Accounts WHERE Username='$_Post['Username']'");

if ($result == '$_post['Password']')
{
echo 'Logged in succesfully';
}

mysql_close($con)
?>

---

Quote:

---

'$_Post['Username']'

---

is your problem.

You cant have ' ' ' '

Put it into a variable first.

Although that is a problem, it's not the MAIN problem. The problem PHP is nagging at is this:

Code:

---

$result == '$_post['Password']')

---

The error DJ Dan stated will give a mySQL error, not PHP error. Here is the fixed code.

Code:

---

$username = $_POST['Username'];
$result = mysql_query("SELECT Password FROM Accounts WHERE Username="$username");

if ($result == $_POST['Password'])
{
echo 'Logged in successfully';
}

---