Subject | RE: [firebird-php] php4-interbase and select with no result |
---|---|
Author | Alan McDonald |
Post date | 2004-08-08T12:00:34Z |
I just tried it - it's the *,
give it a proper list of fields and it works fine
Alan
$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
[Non-text portions of this message have been removed]
give it a proper list of fields and it works fine
Alan
$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
[Non-text portions of this message have been removed]