MySQL problem - stumped
| From: | John Vanderbeck | Date: | Sat, 10 Mar 2001 18:58:09 +0000 |
| Subject: | MySQL problem - stumped | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-43327@lists.php.net to get a copy of this message | ||
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