what field type is MCC? it's not an integer is it?
-----Original Message-----
From: hbanjo9000 [mailto:hbanjo9000@...]
Sent: Sunday, August 08, 2004 7:24 PM
To: firebird-php@yahoogroups.com
Subject: [firebird-php] php4-interbase and select with no result


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




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]