Have you tried running the query in isql and making sure the results are
correct? If so then you know the problem is not with the query.

-steve

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:
>
> 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?
>
> 1312312313212312
>
> 3463622213212312Venda suspensa !!!
>
> 3406303013212312Venda suspensa !!!
> 81451340
> 3462253613212312Venda suspensa !!!
> 3406848881451340
> 3462253691410033Venda suspensa !!!
> 3406848881451340
> 3462253691410033Venda suspensa !!!
> 3406848881451340
> 3462253691410033Venda suspensa !!!
> 3406848881451340
> 3462253691410033Venda suspensa !!!
>
> This value continues to repeat till the end of the results, but the other
> fields are all correct, but those two keep freaking repeating.
>
> Anyone already saw something like it somewhere? I dont have ANY ideas what
> could be the problem, i ve checked EVERYTHING and theres nothing wrong with
> my code, the same code with another table return correct values, i dont know
> what to do :(
>
> Any help and ideas are welcome.
>
> Thanx in advance,
>
> Fábio.
>
>
> [Non-text portions of this message have been removed]
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>