At 01:58 PM 3/10/01 -0500, John Vanderbeck wrote:
You are using && in your statement ... should be "AND"
.
>The following code is giving an me problems, I can't figure it out to save
>my soul. The last line gives:
>
>Here is the code:
>
>$link = db_connect();
>$query = "UPDATE Users SET firstname='$firstname', lastname='$lastname'
>WHERE username='$user' && password='$password'";
>$result = mysql_query($query, $link);
>$err = mysql_error();
>echo "Errors:".$err;
>$rows = mysql_affected_rows($result);
>
>And here is the output:
>Errors:
>Warning: Supplied argument is not a valid MySQL-Link resource in
>/****/*****/****/**********.********.***/db.php on line 147
>
>Line 147, is the last line in the above snippet. I cleared out the path
>name for security, no offense intended :)
>
>Now, I KNOW that the db_connect() function is not the problem, as I use it
>in many other places in this script with no errors. What am I missing?
>
>- John Vanderbeck
>- Admin, GameDesign
>
>
>--
>PHP General Mailing List (http://www.php.net/)
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail: [EMAIL PROTECTED]
##########################################################
# Rick St Jean,
# [EMAIL PROTECTED]
# President of Design Shark,
# http://www.designshark.com/
# Quick Contact: http://www.designshark.com/messaging.ihtml
# Tel: 905-684-2952
##########################################################
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]