ifx_num_rows

(PHP 4, PHP <=5.2.0)

ifx_num_rows — Count the rows already fetched from a query

说明

int ifx_num_rows ( resource $result_id )

Gives the number of rows fetched so far for a query with result_id after a ifx_query() or ifx_do() query.

参数

result_id: result_id is a valid resultid returned by ifx_query() or ifx_prepare() (select type queries only!).

返回值

Returns the number of fetched rows or FALSE on errors.

参见

ifx_num_fields() - Returns the number of columns in the query

User Contributed Notes

evandrosimenes at hotmail dot com 13-Jan-2009 01:10


if you use this function following:





<?php


$query = ifx_query("SELECT * FROM systables", $connection);


$rows  = ifx_num_rows($query);


?>





this way it doesn't work...





the correct is:





<?php


$query = ifx_query("SELECT * FROM systables", $connection);


$fetch = ifx_fetch_row($query);


$rows  = ifx_num_rows($query);


?>





this way it work...





the informix doesn't returns anything (only with ifx_num_rows) if you don't open the results of query (with ifx_fetch_row)

icespawn11882 at hotmail dot com 21-Apr-2005 12:56


This function give always 0 as result so I used ifx_affected_rows to count rows of a query's result...



An example of this function:



$conn_id = ifx_connect("db", "user", "password");

$res_id = ifx_query("select * from systables", $conn_id);

$res = ifx_affected_rows($res_id);

echo $res;



$res contains the number of rows in the result of the query after his execution.



Para Massimiliano