ID: 15342 Updated by: [EMAIL PROTECTED] Reported By: manente at interlogica dot it -Status: No Feedback +Status: Closed Bug Type: Informix related Operating System: linux Mandrake 8.1 PHP Version: 4.0.6 New Comment:
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() Previous Comments: ------------------------------------------------------------------------ [2002-10-20 01:45:20] [EMAIL PROTECTED] 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 ------------------------------------------------------------------------ [2002-09-18 02:59:55] 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-02-02 06:44:15] manente at interlogica dot it <? $connid=ifx_connect("[EMAIL PROTECTED]", "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! ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=15342&edit=1
