Subject | RE: [firebird-php] php4-interbase and select with no result |
---|---|
Author | Alan McDonald |
Post date | 2004-08-08T12:05:09Z |
[Alan McDonald] have you tried $row[0][1] under this syntax?
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]
Yahoo! Groups Sponsor
ADVERTISEMENT
----------------------------------------------------------------------------
--
Yahoo! Groups Links
a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-php/
b.. To unsubscribe from this group, send an email to:
firebird-php-unsubscribe@yahoogroups.com
c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]
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]
Yahoo! Groups Sponsor
ADVERTISEMENT
----------------------------------------------------------------------------
--
Yahoo! Groups Links
a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-php/
b.. To unsubscribe from this group, send an email to:
firebird-php-unsubscribe@yahoogroups.com
c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]