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:[EMAIL PROTECTED]]
> 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: [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]
>
--
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]
