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 :(

On 12/12/05, Steve Wiser <steve@...> wrote:
>
> 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
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> 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
>
>
> - Visit your group "firebird-support<http://groups.yahoo.com/group/firebird-support>"
> on the web.
>
> - To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com<firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
> - Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service <http://docs.yahoo.com/info/terms/>.
>
>
> ------------------------------
>


[Non-text portions of this message have been removed]