php.exe application error. Please advise !

[Guest_imported]

Hi there, thanks for reading my question.

I am running php4 under windows 2000, apache 1.3.x and as database I am using Interbase 6.0
Php is running perfectly.

The problem is when trying to read data in a while statement from the database. In particular i have written :

$dbh = ibase_connect ($hostname, $DBUsername, $DBPassword);

$stmt = "SELECT * FROM links";
$sth = ibase_query ($dbh, $stmt);

while ($row = ibase_fetch_object ($sth) ) //problem here
{
echo $row->L_NAME;
}

ibase_close ($dbh);

Up to the while statement everything is fine. The connection is set correctly and the query is ran.
The problem is when i say : while ($row = ibase_fetch_object ($sth) )

After the execution of that line i get : Application error. Click ok to close, cancel to debug.

The interesting thing is tha t if i dont use a while but :
$row = ibase_fetch_object ($sth) ;
echo $row->L_NAME;

it works fine.

I tried ibase_fetch_row and get the same error.

I would be very grateful if you could advise me on the matter.

Thank you very much.
Leon

 

[inlandpac]

I apologize that nobody has responded to your post.

I have worked on this quite extensively, and I am now wondering if there is a problem with your php_interbase.dll

Have you researched this in other places such as on deja or some newsgroup therein?

chad. ICQ: 54380631