RE: [PHP] MySQL problem - stumped

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 > > > > > >-- > >PHP General Mailing List (http://www.php.net/) > >To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > >For additional commands, e-mail: php-general-help@lists.php.net > >To contact the list administrators, e-mail: php-list-admin@lists.php.net > > ########################################################## > # Rick St Jean, > # rstjean@internet.look.ca > # 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: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >