Re: MySQL problem - stumped

Well, PHP seems to think that $link is not working, so your db_connect() is in fact, the problem. You say you use db_connect several times in this script without problem - why do you keep connecting to the same database repeatedly in the same script - one connection will do for all your queries. HTH, Julian on 3/10/01 12:11 PM, John Vanderbeck at agathorn@cfl.rr.com wrote: > > > Ok, > > Well I got 3 replies saying that my use of && is incorrect, and that I > should use AND. This confused me for 2 reasons. First, is that I use && in > all my other SELECT queries, with no problems. In fact, the MySQL docs, > show the use of &&, not AND. Secondly, because if I had a bad query, it > should have given me some sort of error when I output mysql_error(). No? > > However, I did of course try changing it to AND instead of &&. But the > problem remains. Same error. > Any other ideas? > > - John Vanderbeck > - Admin, GameDesign > >> -----Original Message----- >> From: Rick St Jean [mailto:rstjean@internet.look.ca] >> Sent: Saturday, March 10, 2001 2:09 PM >> To: PHP User Group >> Subject: Re: [PHP] MySQL problem - stumped >> >> >> 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 >>> >>> -- Julian Wood Learning Technologies and Digital Media University of Calgary