mysql_num_rows and mysql_affected_rows return the same result when executing SELECT SQL

Question

My test code:

    $connection = mysql_connect('localhost', 'root', '') or die(mysql_error());

    mysql_select_db("chaoge", $connection);

    mysql_query("SET NAMES UTF8", $connection);

    $rs = mysql_query("SELECT * FROM babel_node WHERE nod_pid = 2101", $connection);

    $nu = mysql_affected_rows();
    echo $nu;

It says that mysql_affected_rows works with INSERT, UPDATE, REPLACE and DELETE。

Why I can also get the right result through mysql_affected_rows ?

Any help and suggestions will be highly appreciable。

SergeyAn · Accepted Answer · 2015-09-24 04:37:31Z

0

Here is what I found on the internet.

mysql_affected_rows() for a SELECT indicates the number of rows which were found. mysql_num_rows() indicates how many rows were actually returned. They may not be the same, IIRC, if you have a LIMIT clause or similar. GROUP BY may also cause a difference.

Source

See answers on the source at the bottom.

answered Sep 24, 2015 at 4:37

SergeyAn

7646 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

tripleCC Over a year ago

Thank you very much . Very helpful to me

LeViNcE · Accepted Answer · 2015-09-24 04:00:05Z

0

I suggest you must use

MySQLi http://php.net/manual/en/book.mysqli.php

or

PDO_MySQL http://php.net/manual/en/ref.pdo-mysql.php

for updated method of accessing database since your method was deprecated in PHP 5.5.0

answered Sep 24, 2015 at 4:00

LeViNcE

3141 gold badge6 silver badges15 bronze badges

Collectives™ on Stack Overflow

mysql_num_rows and mysql_affected_rows return the same result when executing SELECT SQL

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related