Bernhard Doebler wrote:

> can one of you please tell me how to find out if a query on an InterBase database was > successful and how man rows are returned if the query was made with the ibase_query - > function?
>

<?php
$resultset = ibase_query($conn->_connectionID, $sql, <optional place
holder params>);
if ($resultset === false) {
/*we have a problem */
} else {
/*all was fine so carry on */
}
?>

where $conn is my connection object and $sql is the sql!

AFAIK there is no way to return the "row count" of the result set short
of either:
1. walking the result set and counting the rows - and stopping if you
have too many
2. running a select count(*) - but this is double the overhead and not
guarenteed to be correct in a multiuser environment

Have you looked at database abstraction like adodb - then you can change
from interbase to eg mysql and back again "painlessly"?

HTH
Ian