Subject php4-interbase and select with no result
Author hbanjo9000
Hi to everybody,
here's my problem, a simple query in a php4 script doesn't
display any rows but if I made same SELECT using qli I've got
a lot of rows. Where's the problem?
Scrips works fine for all other dbs

$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++;
}

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

The same thing happened using ibWebAdmin...

Any Ideas?

thanks in advance

Haran