Fabio Gomes wrote:

> I dont know if this thing is a php problem or a firebird problem.. i never
> saw something so weird in my life... the problem is the folowing:
>
> I have a query, this one:
>
> SELECT CLIENTES.*, CIDADES.CID_NOME, CIDADES.CID_ESTADO
> FROM CLIENTES
> JOIN CIDADES ON (CLIENTES.CID_COD=CIDADES.CID_COD)
>
> It works fine, but the problem is in the results, it takes a value, and
> keeps printing the SAME value in all the rest of the results, but the weird
> stuff.. is that it prints one line, skips one and print the value again like
> this:

We cleared this up on the support list ;)
The answer was NULL entries in the string fields :)

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services
Treasurer - Firebird Foundation Inc.