Posted by MS on 11/12/07 19:15

Jonas Werres emailed this:
>> "Warning: mysql_affected_rows(): supplied argument is not a valid
>> MySQL-Link resource in /home/fakeuser/public_html/test/adduser.php on
>> line 104"
>
> PHP Manual:
> For SELECT, SHOW, DESCRIBE, EXPLAIN and other statements returning
> resultset, mysql_query() returns a resource on success, or FALSE on error.
> For other type of SQL statements, UPDATE, DELETE, DROP, etc,
> mysql_query() returns TRUE on success or FALSE on error.
>
> So: Because TRUE is not a Resource, which is expected.
> Ha, that was easy.
>
> Indeed, mysql_affected_rows() does NOT expect the return value of
> mysql_query(), but the connection resource:
> http://de2.php.net/manual/en/function.mysql-affected-rows.php
>
> So, to but it in a nutshell: RTFM!

Oh, I'm so sorry! I did RTFM, but *obviously* not very effectively.

Thanks for the help.

Feeling humbled and very sorry.

[Back to original message]