ifx_num_fields
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)
ifx_num_rows
(PHP 4, PHP <=5.2.0)
ifx_num_rows — クエリから既に取得された行の数を数える
説明
int ifx_num_rows
( resource $result_id
)
ifx_query() または ifx_do() クエリの後、result_id を有する クエリに関してこれまで取得された行の数を返します。
返り値
取得した行の数、あるいはエラー時に FALSE を返します。
add a note
User Contributed Notesifx_num_rows
evandrosimenes at hotmail dot com
13-Jan-2009 12:10
13-Jan-2009 12:10
icespawn11882 at hotmail dot com
20-Apr-2005 10:56
20-Apr-2005 10: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