Hi Fabio,

Shouldn't this:
JOIN CIDADES ON (CLIENTES.CID_COD=CIDADES.CID_COD)";

not be:
JOIN CIDADES ON (CLIENTES.CLI_COD=CIDADES.CID_COD)";
^^^

See you
Werner


Lester Caine wrote:

> We still don't know which version of PHP you are working with?
> The PHP5 Interbase driver had a lot of work which was never back ported
> to PHP4 :(
>
> Fabio Gomes wrote:
>
>
>>I dont know what more i can try, if i do this:
>>
>>$sql = "SELECT C.CLI_COD,
>> C.CLI_NOME,
>> C.CLI_ENDERECO,
>> C.CLI_BAIRRO,
>> C.CLI_CEP,
>> C.CLI_LIM_CREDITO,
>> C.CLI_CNPJ_CPF,
>> C.CLI_IE_RG,
>> C.CLI_DDD,
>> C.CLI_TELEFONE,
>> C.CLI_CELULAR,
>> C.CLI_OBS,
>> CIDADES.CID_NOME,
>> CIDADES.CID_ESTADO
>> FROM CLIENTES C
>> JOIN CIDADES ON (CLIENTES.CID_COD=CIDADES.CID_COD)";
>>
>>#$clientes = consulta($conexao_id, $sql);
>>$clientes = ibase_query($conexao_id, $sql);
>>while($cli = ibase_fetch_row($clientes)) {
>> print_r($cli) . "<br /><br />";
>>}
>>
>>It return me the SAME value.
>
>
> With some of the fields? - C.CLI_COD and C.CLI_NOME are still OK but no
> others?
>
>
>>If i take off the JOIN on the query, it still repeat the results.. the query
>>just works like this:
>>
>>$sql = "SELECT C.CLI_COD,
>> C.CLI_NOME,
>> C.CLI_ENDERECO,
>> C.CLI_BAIRRO,
>> C.CLI_CEP,
>> C.CLI_LIM_CREDITO,
>> CIDADES.CID_NOME,
>> CIDADES.CID_ESTADO
>> FROM CLIENTES C
>> JOIN CIDADES ON (CLIENTES.CID_COD=CIDADES.CID_COD)";
>>
>>If i remove the last fields (that are those wich are repeating) the query
>>works.. but it doesnt solve my problem...
>
>
> So the problem is one of
> > C.CLI_CNPJ_CPF,
> > C.CLI_IE_RG,
> > C.CLI_DDD,
> > C.CLI_TELEFONE,
> > C.CLI_CELULAR,
> > C.CLI_OBS,
>
> Is it JUST one of those fields?
> In which case what type of field is it and what should be in it?
>
>
>>Maybe i just just send the server flying out of the window -_-
>
>
> Just wasted 2 hours trying to work out why a program would not run in
> the Borland Debugger - turns out that there was a dll missing from XP
> that is present in W2k. I just had not twigged that I'd not worked on
> that program since I had to move laptops and the new one refused to
> install W2k - because the BIOS was too *OLD*.
>
> Got some other contacts pulling hair out over MySQL 4.0 and 4.1 - how do
> you backport a database since the software NOW fails on the later
> versions of MySQL.
>
> So the sledge hammer next to the equipment rack is standard practice ;)
>