need some help

[justinh]

<?php
session_start();


include("connect.php");



$username = $_POST['username'];
$password = $_POST['password'];

$data = mysql_query("SELECT * FROM users WHERE username='$username' and password='$password');


if (mysql_num_rows($data) = 1) {

$_SESSION['loggedin'] = 1;
echo "Login Complete. Click <a href=\"index.php\">here</a> to continue.";

} else {

echo "Password/Username incorrect. Please try again.";

}

?>

gives me an error of

[code]Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /homepages/29/d119570661/htdocs/wmptest.com/HuntReserver/checklogin.php on line 17

im sure this is an easy fix, but i just can't seem to see what's wrong with the code. thanks in advance

[.josh]

Forgot the closing " on your query string.

[justinh]

ugh i feel dumb.. thanks very much

[.josh]

Other errors I found that you will run into after fixing that:

 

- your if statement has = instead of == (= is assignment, == is comparison)

- forgot to escape the opening quote around index.php in your echo