RE: [PHP] MySQL problem - stumped

I do'nt connect multiple times..its one large script that handles different tasks based on the settings of control vars. I just like to keep it all together. The $link has to be valid, or it would be erroring out on the mysql_query() call. Which it is not, and it reports no errors with that call. - John Vanderbeck - Admin, GameDesign > -----Original Message----- > From: Julian Wood [mailto:woodj@ucalgary.ca] > Sent: Saturday, March 10, 2001 2:28 PM > To: John Vanderbeck; PHP User Group > Subject: Re: [PHP] 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 > >