Get error message, need help
| From: | Cornelia Boenigk | Date: | Mon, 16 Dec 2002 16:20:49 +0000 |
| Subject: | Get error message, need help | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-24177@lists.php.net to get a copy of this message | ||
Hi David
> // Query Database with username and encrypted password
> #$myquery = "SELECT * FROM user WHERE username = '" . $user
> #$myquery = .'" AND password = '" . crypt($password, "xpz8ty") .
> "'";
> #$result = mysql_query($myquery);
In the first line of the query there is no semicolon at the end of the
line.
To define strings over several lines you have to write *.=* instead of *=.*
Try this:
// Query Database with username and encrypted password
$myquery = "SELECT * FROM user WHERE username = '" . $user."'";
$myquery .= " AND password = '" . crypt($password, "xpz8ty") .
"'";
$result = mysql_query($myquery);
Regards
Conni