Subject Re: [ib-support] Get num rows from firebird query with php
Author Robbi
""supertokkie"" <martinstuij@...> schrieb im Newsbeitrag
news:aopdem+dqvh@......
> How can I get the number of rows from a firebird query with php?
> There is no standard function in php.

Hi Martin,

I use the following statements to get this info from a PostgreSQL database:

$SQL = "select * from ATable";

$RESULT = pg_Exec($DBH, $SQL);
if(!$RESULT) {
echo "Could not execute select statement";
if ($DBH) pg_Close($DBH);
exit;
}
$NUM_ROWS = pg_NumRows($RESULT);
if(!$NUM_ROWS) {
...
} else {
$MA_FIRMA = pg_Result($RESULT, 0, "firmenname");
...
}
pg_FreeResult($RESULT);
pg_Close($DBH);

Maybe you can find something similar in the FireBird interface.

Robbi