Grr..
Thank You! God I feel like the idiot now. Why didn't I see that? Heck why
didn't anyone else see it either :) I'm so used to using $rows =
mysql_num_rows($result), that I just did the same thing here. But your
right, the docs say THIS one takes a LINK and not a RESULT identifier. Grr..
Thanks again. Your a deadline saver :)
- John Vanderbeck
- Admin, GameDesign
> -----Original Message-----
> From: Christian Reiniger [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, March 10, 2001 2:32 PM
> To: PHP User Group
> Subject: Re: [PHP] MySQL problem - stumped
>
>
> On Saturday 10 March 2001 19:58, you wrote:
> > 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 :)
>
> This one?
> > $rows = mysql_affected_rows($result);
>
> Try
> $rows = mysql_affected_rows($link);
>
> --
> Christian Reiniger
> LGDC Webmaster (http://sunsite.dk/lgdc/)
>
> The use of COBOL cripples the mind; its teaching should, therefore,
> be regarded as a criminal offence.
>
> - Edsger W. Dijkstra
>
> --
> 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]
