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:

Then we need to know what you are using - version of PHP, and any other
libraries?
If it is a PHP problem then we should discuss it on the firebird-php list ;)

> 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)

I would recommend loosing the '*' and providing the field names since
you are expecting them in the results.

> 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:
>
> ID, NAME, COMENT:
> 01, name1, repeated value
> 02, name2, skip this
> 03, name3, repeated value
> 04, name5, skip this
> 05, name6, repeated value
> 06, name7, skip this
> 07, name8, repeated value
> 08, name9, skip this
>
> The ID and NAME are correts, and the other two values keep repeating, here
> are my REAL results, its kinda messy ok?

Before going to the next step we need to know HOW you are stepping
through the results. I presume that CIDADES.CID_ESTADO provides the
third column? is it a string or a blob?

Need more information to go any further!

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