PHP error.

[taekwondokid42]

Parse error: syntax error, unexpected T_STRING in /home/mike/public_html/loginp.php on line 13


Line 13 reads like this:

$sql = SELECT FROM users WHERE name == "$username" AND pass == "$password";

what is the problem?

There are no syntax errors in the line above or below it.

 

[sms_dre]

you need single quote marks round the whole query as its a string (and you're already using doubles inside the string):

$sql = 'SELECT FROM users WHERE name == "$username" AND pass == "$password"';

 

[taekwondokid42]

thank you.

 

[deadimp]

Be sure to sanitize (escape) your strings to prevent MySQL injection!

 

[*Face]

$sql = 'SELECT FROM users WHERE name == "$username" AND pass == "$password"';

That doesn't look like it'll actually work, since PHP doesn't parse variables in strings with single quotes.

$sql = 'SELECT FROM users WHERE name == "'.$username.'" AND pass == "'.$password.'"';

This should work, always assuming you have proper protection in place.

 

[conker87]

Or do it the logical way:

$sql = "SELECT FROM users WHERE name = '$username' AND pass = '$password'";

I've never seen '==' used ever in MySQL.

 

[taekwondokid42]

Thank you.

I like the last way the best. And if you were wondering, I got the script working now.:biggrin: