RE: [PHP-DEV] PHP 4.0 Bug #4455: ifx_affected_rows() & ifx_num_rows() don't return correct numbers of rows.

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 > From: jfuertes@maz.es > Operating system: Red Hat Linux 6.1 > PHP version: 4.0 Release Candidate 2 > PHP Bug Type: Misbehaving function > Bug description: ifx_affected_rows() & ifx_num_rows() don't > return correct numbers of rows. > > ifx_affected_rows() allways returns 1 even if a query result is empty. Because no rows are AFFECTED, and cannot be, with select. See Informix manual for SQLCA record, and ifx_getsqlca() function. > ifx_num_rows() allways returns 0 even if a query result got rows. This function is often misunderstood, probably because it have name similar to num_rows function in other PHP db interfaces that DO return actual number of returned rows. In short, returned number is SQL's engine optimizer's guess about the number of rows to be returned. See same as above. ....snip.... If you are really interested in number of rows returned, you will need to do SELECT COUNT(*) again with same where-part, or fetch row-by-row and count them. If you just want to see if row exists, do something like $res_id = ifx_query($sql, $connid); $row = ifx_fetch_row ($res_id, "FIRST"); if ( $row == FALSE) {$NOTFOUND=true;}else{$NOTFOUND=false;} Yes, we probably need REAL ifx_num_rows() function. This is not a bug. It may be a feature request. Should be closed. Yours, Andrej Falout, http://www.falout.com ICQ 7628616 #----------------------------------------------------------------- globals "std_disclaimer.4gl" "Venus is still under construction. Thank you for your patience and we apologize for the inconvenience." - Match.com online dating site. -----BEGIN PGP SIGNATURE----- Version: PGPfreeware 6.0.2i iQA/AwUBOSABuRZH34ibpTRkEQINDQCgofZKYyor5kIOZnCx1p0URdINldIAoPeF ZEcwk86PjD/RDtxKGrdQuENi =2fLH -----END PGP SIGNATURE-----