For those who have problem with returning values from Stored Procedures in
PHP-Interbase,  I have found a solution.   Use a select sentence like
this:
select * from sp_prodecure(param, ...)
However, it is important that the procedure has a SUSPEND statement or
else the procedure won't return any values.

But the "message length" (see above note) bug that you encounter
when you try to execute a procedure should be fixed !

If someone has a trouble PHP4 - InterBase, this example works well:
.........
ibase_pconnect($host, $username, $pass);
$sth=ibase_query("SELECT * FROM TABLE WHERE X = Y");
while ($row = ibase_fetch_row($sth)) 
	{
            ...........

Hello PHP Mania,

i have made a paging for PHP with Interbase...... :)

i hope it usefull and work....:)

it`s a litle bit of example :

<?
$connection = ibase_connect($yourdb, $user, $password);

$filename = BASENAME(__FILE__);
$strsql = "Your SQL";
$result = ibase_query($connection, $strsql);

function ibase_num_rows($query) { //I have pick it from
[email protected]
 $i = 0;
 while (ibase_fetch_row($query)) {
    $i++;
  }
return $i;
}
$nrow = ibase_num_rows($result);//sum of row

$strSQL = "your SQL";
$result = ibase_query($connection, $strSQL);

if (!isset($page))
  $page = 1;

$$i = 0;
$recperpage = 4;
$norecord = ($page - 1) * $recperpage;
if ($norecord){
  $j=0;
  while($j < $norecord and list($code, $name)=
ibase_fetch_row($result)){

  $j++;
  }
}
echo "<table>";
while (list($code, $name)= ibase_fetch_row($result) and $i <
$recperpage){

  ?>
	<tr>
		<td width="5%"><? echo $code; ?></td>
		<td><? echo $name; ?></td>
	</tr>
<?
$i++;
}

$incr = $page + 1;
if ($page > 1) $decr = $page - 1;

$numOfPage = ceil($nrow/$recperpage);
?>
	<tr>
<td colspan="3" align="center"><?if ($page
<= 1)
					echo "<span>Prev</span>";
				  else
				  	echo "<a
href=".$filename."?page=".$decr.">Prev</a>";
				?>
				&nbsp;&nbsp;
				<?if ($page == $numOfPage)
					echo "<span>Next</span>";
				  else
				  	echo "<a
href=".$filename."?page=".$incr.">Next</a>";?>
</td>
</tr>
</table>