You should write: $myquery = "SELECT * FROM user WHERE username = '{$user}' ..." ; As a bonus, it is much more readable. Ignatius ____________________________________________ ----- Original Message ----- From: "David" <cddllc@hotmail.com> To: <php-db@lists.php.net> Sent: Monday, December 16, 2002 2:16 AM Subject: Get error message, need help > Hello all, > > I am new to PHP so I am going to need some help. > > I am trying to create a admin login page. But I am getting this error > message: > > Parse error: parse error, unexpected T_VARIABLE in c:\program files\apache > group\apache\htdocs\sunwestsilver\admin\tmpi5pcf76sy9.php on line 43 > > tmpi5pcf76sy9.php is generated by Dreamweaver MX as a temp file from > admin.php > > It is coming from this line: > > this is line 43 code > > # $myquery = .'" AND password = '" . crypt($password, "xpz8ty") . "'"; > > The complete code is: > > // Query Database with username and encrypted password > #$myquery = "SELECT * FROM user WHERE username = '" . $user > #$myquery = .'" AND password = '" . crypt($password, "xpz8ty") . "'"; > #$result = mysql_query($myquery); > #if (!$result) > #{ > # $error = "Cannot run Query"; > #return($error); > #} > > Any help will be nice. > > I got this code from Dreamweaver MX: PHP Web Development pg. 257 > > Thanks > > David > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php