ifx_num_rows

(PHP 4, PHP <=5.2.0)

ifx_num_rowsCount the rows already fetched from a query

Description

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.

Parameters

result_id

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

Return Values

Returns the number of fetched rows or FALSE on errors.

See Also

Коментарии

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
2005-04-20 18:56:36
http://php5.kiev.ua/manual/ru/function.ifx-num-rows.html
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)
2009-01-13 06:10:26
http://php5.kiev.ua/manual/ru/function.ifx-num-rows.html

    Поддержать сайт на родительском проекте КГБ