|  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
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If this is not your bug, you can add a comment by following this link.
If this is your bug, but you forgot your password, you can retrieve your password here.
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-2024 The PHP Group
All rights reserved.
Last updated: Mon May 27 23:01:30 2024 UTC