php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Doc Bug #55059 Working of mysql_affected_rows() after SELECT
Submitted: 2011-06-29 00:11 UTC Modified: 2011-07-01 18:57 UTC
From: torbasow at mail dot ru Assigned:
Status: Wont fix Package: Documentation problem
PHP Version: Irrelevant OS:
Private report: No CVE-ID: None
View Developer Edit
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: torbasow at mail dot ru
New email:
PHP Version: OS:

 

 [2011-06-29 00:11 UTC] torbasow at mail dot ru 
Description:
------------
---
From manual page: http://www.php.net/function.mysql-affected-rows%23Description
---
There are nothing about calling mysql_affected_rows() after SELECT. It is logical that it would return 0 because the number of affected rows is zero or the number of affected rows by previous query.

However in practice it returns the number of rows returned by a SELECT! For it is said in MySQL manual that "For SELECT statements, mysql_affected_rows() works like mysql_num_rows()" (http://dev.mysql.com/doc/refman/5.0/es/mysql-affected-rows.html).

This feature should be noted in manual.

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2011-07-01 18:57 UTC] frozenfire@php.net
-Status: Open +Status: Wont fix
 [2011-07-01 18:57 UTC] frozenfire@php.net 
The behaviour of the mysql_affected_rows() function after calling a SELECT is 
unstable, and varies by MySQL server versions, and I think even with PHP 
versions. I don't think we can reasonably document this behaviour in a way that 
would be future-safe or even understandable to most people.

My suggestion would be to not use this function in this way, as the code will be 
highly non-portable.

As such, I'm changing this bug to wont-fix. If you dispute that, please leave a 
comment.
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved. 		Last updated: Wed Jul 02 07:01:33 2025 UTC