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

go to bug id or search bugs for

Bug #15342 Informix ifx_num_rows
Submitted: 2002-02-02 06:44 UTC Modified: 2003-02-26 09:21 UTC
Votes:3
Avg. Score:4.0 ± 0.8
Reproduced:2 of 2 (100.0%)
Same Version:0 (0.0%)
Same OS:0 (0.0%)
From: manente at interlogica dot it Assigned:
Status: Closed Package: Informix related
PHP Version: 4.0.6 OS: linux Mandrake 8.1
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: manente at interlogica dot it
New email:
PHP Version: OS:

 

 [2002-02-02 06:44 UTC] manente at interlogica dot it 
<? 
$connid=ifx_connect("dbnamw@ol_frzz", "informix", 
"zzzzz") or die("Error"); 

$result = ifx_query("SELECT * FROM tabel", $connid) or 
die("Error"); 

$rc = ifx_num_rows($result); 
echo $rc; // <--- $a is always 0 


ifx_free_result($result); 


?> 




The result of ifx_num_rows($result) is always 0!

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2002-09-18 02:59 UTC] chuakialoong at yahoo dot com 
Dear PHP Developer,

I am facing same problem with ifx_num_rows() as well. It always return Zero.

(1) PHP Syntax:
$conn_id  = ifx_pconnect($dbname, $dbuser, $dbpass) OR die ("Connection error!");

$res_id   = ifx_query($sql_stat, $conn_id) OR die ("SQL Error!");

#-- It always return 0, even there is records found --#
echo "Numrow = " . ifx_num_rows($res_id);


(2) This is my spec:
HP-UX 11.00
Informix Dynamic Server Version 7.31.UC6AX7
Informix CSDK 2.40.HC1
INFORMIX-ESQL Version 9.30.HC1
PHP 4.1.2 release
Apache 1.3.23

(3) Appreciate if this bug (if it has been justified as bug) can be fixed as soon. Thank you.

Regards,
Koma
 [2002-10-20 01:45 UTC] iliaa@php.net 
Please try using this CVS snapshot:

  http://snaps.php.net/php4-latest.tar.gz
 
For Windows:
 
  http://snaps.php.net/win32/php4-win32-latest.zip
 [2003-02-26 09:21 UTC] nobbie@php.net 
Informix doesn't have support for returning the number of rows in a result set/cursor. The closest thing to it is to use sqlerrd[3] which is IMHO an inaccurate estimate.

ifx_num_rows() returns the number of rows processed or retrieved by ifx_fetch_row()
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved. 		Last updated: Thu Dec 26 18:01:31 2024 UTC