I think that a screenshot could help:

http://img231.imageshack.us/img231/4240/fb6dr.jpg

The CID_ESTADO is a CHAR(2) field, and the other filelds are:

INTEGER and VARCHAR, but both are giving me problems :(

If you want i can upload the structure or even the database somewhere, but
this isnt the first time i had this problem with this table, the first time
i didnt manage how to fix, but it wasnt important so i exchanged one field
for another.. but now i need to export everything :(

thanx for any help.

On 12/12/05, Lester Caine <lester@...> 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!
>
> --
> Lester Caine
> -----------------------------
> L.S.Caine Electronic Services
> Treasurer - Firebird Foundation Inc.
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> 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
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>
>
>
> SPONSORED LINKS
> Technical support<http://groups.yahoo.com/gads?t=ms&k=Technical+support&w1=Technical+support&w2=Computer+technical+support&w3=Compaq+computer+technical+support&w4=Compaq+technical+support&w5=Hewlett+packard+technical+support&w6=Microsoft+technical+support&c=6&s=196&.sig=-XIO8GxY6hqd3NaD5WSEyw> Computer
> technical support<http://groups.yahoo.com/gads?t=ms&k=Computer+technical+support&w1=Technical+support&w2=Computer+technical+support&w3=Compaq+computer+technical+support&w4=Compaq+technical+support&w5=Hewlett+packard+technical+support&w6=Microsoft+technical+support&c=6&s=196&.sig=B29J78SYXnNTjjMFBMznqA> Compaq
> computer technical support<http://groups.yahoo.com/gads?t=ms&k=Compaq+computer+technical+support&w1=Technical+support&w2=Computer+technical+support&w3=Compaq+computer+technical+support&w4=Compaq+technical+support&w5=Hewlett+packard+technical+support&w6=Microsoft+technical+support&c=6&s=196&.sig=7_je1A94xs82CFXUjEqA6g> Compaq
> technical support<http://groups.yahoo.com/gads?t=ms&k=Compaq+technical+support&w1=Technical+support&w2=Computer+technical+support&w3=Compaq+computer+technical+support&w4=Compaq+technical+support&w5=Hewlett+packard+technical+support&w6=Microsoft+technical+support&c=6&s=196&.sig=2zMAuRCo5cJrVBr1Bxa3_w> Hewlett
> packard technical support<http://groups.yahoo.com/gads?t=ms&k=Hewlett+packard+technical+support&w1=Technical+support&w2=Computer+technical+support&w3=Compaq+computer+technical+support&w4=Compaq+technical+support&w5=Hewlett+packard+technical+support&w6=Microsoft+technical+support&c=6&s=196&.sig=_ytYU7aXb57AVaeUfmvLcA> Microsoft
> technical support<http://groups.yahoo.com/gads?t=ms&k=Microsoft+technical+support&w1=Technical+support&w2=Computer+technical+support&w3=Compaq+computer+technical+support&w4=Compaq+technical+support&w5=Hewlett+packard+technical+support&w6=Microsoft+technical+support&c=6&s=196&.sig=4hRo6NXYavRAbTkaYec5Lw>
> ------------------------------
> 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]