#15342 [Opn->NoF]: Informix ifx_num_rows

ID: 15342 Updated by: iliaa@php.net Reported By: manente@interlogica.it -Status: Open +Status: No Feedback Bug Type: Informix related Operating System: linux Mandrake 8.1 PHP Version: 4.0.6 New Comment: 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 Previous Comments: ------------------------------------------------------------------------ [2002-09-18 02:59:55] chuakialoong@yahoo.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@interlogica.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! ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=15342&edit=1