Posted by Jonas Werres on 11/12/07 18:26

> "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!

[Back to original message]