Subject | php4-interbase and select with no result |
---|---|
Author | hbanjo9000 |
Post date | 2004-08-08T09:24:12Z |
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
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