ifx_num_rows()
(PHP 4, PHP 5 < 5.2.1)
Count the rows already fetched from a query
说明
ifx_num_rows(resource $result_id): int
Gives the number of rows fetched so far for a query with$result_idafter a ifx_query() or ifx_do() query.
参数
- $result_id
$result_idis 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
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)
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