hbanjo9000 wrote:

> Scrips works fine for all other dbs

What other dbs? Databases or database engines

> $sqlstring = "SELECT * FROM ECC WHERE MCC = '92000000001001'";
> $db = ibase_connect($FileIB,$User,$Pass) or die("OPEN DB ERROR -
> $FileIB");
> $result = ibase_query($db,$sqlstring) or die("QUERY ERROR !!! - " .
> ibase_errmsg());
> while ($row = ibase_fetch_row($result))
> {
> print $row[0];
> $i++;
> }

Looks reasonable - does it work with a different select? Perhaps
including the field names rather than '*'. I've seen problems where the
field list is not known, but the driver is trying to build an
associative listing.

> the db is pretty big (600mb) and that's the only difference
> compare to other ones.
>
> - Apache/1.3.31 (Debian GNU/Linux)
> - firebird 1.5.0.4290-0.i686
> - PHP 4.3.8
> - php4-interbase 4.3.6-1

Only bit I match at the moment is firebird, but that should not make a
difference.

> The same thing happened using ibWebAdmin...

Presume you can see data in the table from ibWebAdmin's view table?

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services