Subject | Weird php and firebird problem, repeating values |
---|---|
Author | Fabio Gomes |
Post date | 2005-12-12T20:44:59Z |
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]
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]