> I didnt try isql, but in ibwebadmin and IBExpert the query is ok,

its just

> in the php that i m having this problem, but i need to run it using

php :(

If it runs fine in these tools then your problem has NOTHING to do
with Firebird. It is either a problem with your PHP or with your PHP
driver for Firebird.

I would suggest you take it to the Firebird-PHP list where they can
work out what is wrong.

Adam