|  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #2410 ifx_affected_rows error
Submitted: 1999-09-29 21:46 UTC Modified: 1999-10-03 23:22 UTC
From: kangkw at prolagns dot co dot kr Assigned: jah (profile)
Status: Closed Package: DBM/DBA related
PHP Version: 3.0.12 OS: Solrais6.0
Private report: No CVE-ID: None
View Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or if you reported this bug, you can edit this bug over here.
Block user comment
Status: Assign to:
Bug Type:
From: kangkw at prolagns dot co dot kr
New email:
PHP Version: OS:


 [1999-09-29 21:46 UTC] kangkw at prolagns dot co dot kr
Hello, PHP Developer.
My name's ku-won Kang.
This is the south Korea.

I can't english very well.

So, I have a one problem that is not correspond to the result of a row when after executed 'ifx_affected_rows'.
For exmaple, In this sql statements "select nickname from addressbook where id  = 'kangkw';", table of the 'addressbook' has 4 rows about name of the 'id'. but result of the 'ifx_affected_rows' has only 2 rows. That is same in an other case it's if name of id has 3, 4, 5, anything.
If you possible about the problem, I'll wait for your help as soon as possible.

Thank you. 
Sincerely yours.


Add a Patch

Pull Requests

Add a Pull Request


AllCommentsChangesGit/SVN commitsRelated reports
 [1999-10-03 23:22 UTC] jah at cvs dot php dot net
The documentation for ifx_affected_rows clearly says:

"For inserts, updates and deletes the number is the real number (sqlerrd[2])
of affected rows. For selects it is an estimate (sqlerrd[0]). Don't rely on it."

This is, if I remember it right, because Informix creates the estimate and starts
returning results as fast as it can, before actually fully completing the query.

PHP Copyright © 2001-2022 The PHP Group
All rights reserved.
Last updated: Thu Jun 30 11:05:43 2022 UTC