ifx_num_rows

(PHP 4, PHP <=5.2.0)

ifx_num_rows — Count the rows already fetched from a query

Beschreibung

int ifx_num_rows ( int $result_id )

Gibt nach der Ausführung von ifx_query() oder ifx_do()die Anzahl der Zeilen in der durch result_id gegebenen Ergebnismenge zurück.

add a note User Contributed Notes
ifx_num_rows

evandrosimenes at hotmail dot com
13-Jan-2009 12: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
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

add a note

ifx_pconnect

ifx_num_fields

Last updated: Fri, 30 Oct 2009