ID: 30579
Updated by: [EMAIL PROTECTED]
Reported By: gabriel dot preda at amr dot ro
-Status: Open
+Status: Closed
Bug Type: Documentation problem
Operating System: Not applicable
PHP Version: Irrelevant
New Comment:
This bug has been fixed in the documentation's XML sources. Since the
online and downloadable versions of the documentation need some time
to get updated, we would like to ask you to be a bit patient.
Thank you for the report, and for helping us make our documentation
better.
Previous Comments:
------------------------------------------------------------------------
[2004-10-27 13:54:48] gabriel dot preda at amr dot ro
Description:
------------
<para><function>mysql_affected_rows</function> does not work with
SELECT statements; only on statements which modify records. To retrieve
the number of rows returned by a SELECT, use
<function>mysql_num_rows</function>.</para>
Why... this is not TRUE...
Called after a SELECT query mysql_affected_rows will asta work...
and will act just as mysql_num_rows because PHP's mysql_query calls, by
default, MySQL's mysql_store_result.
If and only if the previous SELECT query was sent with
mysql_unbuffered_query witch will not call MySQL's
mysql_store_result... mysql_affected_rows will return -1 as if an error
ocured.
__2.__
There is not mentioned that if the previous query was REPLACE...
mysql_affected_rows will return doubled results... that is because
MySQL will DELETE and INSERT rows... thus making 2 operations...
All this things are also documented in MySQL Reference Manual whitch
is a good source for info about mysql functions present in MySQL
extension of PHP... not to mention the MySQLi extension.... !
I believe that the above should be included in this functions'
documentation !
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=30579&edit=1
