Just a little interest to add [Lester Caine] :
if in any sql tool (ems,dbworkbench,ibeasy , etc) you see correct
results then, your FB sql is correct :). In other way it is not :).
(php_fetch_array working bad ? )

Also, I would do the following : try to name out needed fields,use left
join/inner join instead,use subselect , write down simple view, use
r/left trim, etc. Use gbak to backup/restore....

Adomas

Lester Caine wrote:

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