Parse error: syntax error, unexpected T CONSTANT ENCAPSED STRING

[ryanharper]

I am getting this error message on my page

"Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING in /home/content/r/y/a/ryanharper/html/login-exec.php on line 58"

line 58 is:

$qry="SELECT * FROM members WHERE login='$login' AND passwd='".md5($_POST['password'])"'AND is_approved = '1'";

i think it has to do with the AND is_approved area. thisis for a password protect page that needs admin approval

any help is greatly appreciated

thx

RH

[d40sithui]

Hmm,
might be that you did not concatenate properly between the md5() and the "AND"(missing dot). See below.
$qry="SELECT * FROM members WHERE login='$login' AND passwd='".md5($_POST['password'])."'AND is_approved = '1'";

[rocknbil]

Correct, but you'll now have a mysql error. :-) add a space before the AND that precedes is_approved.

$qry="SELECT * FROM members WHERE login='$login' AND passwd='" . md5($_POST['password']) . "' AND is_approved = '1'";