Hi friends, my question is simple, this sql returns successfull in the PHPMYADMIN query, however when I put in my own php code, it fails. What could be?
1-The code:
$query = "Select concat(BASI_010.GRUPO_ESTRUTURA,'.', BASI_010.SUBGRU_ESTRUTURA,'.',BASI_010.ITEM_ESTRUTURA) as aviamento,
BASI_010.CODIGO_VELHO,
concat( BASI_030.DESCR_REFERENCIA,' ',
(select BASI_510.DESCRICAO from BASI_510
where BASI_510.COD_TIPO_AVIAMENTO = BASI_030.COD_TIPO_AVIAMENTO
and BASI_510.SEQ_ATRIBUTO = 01
and BASI_510.COD_ATRIBUTO = BASI_030.COD_ATRIBUTO_01),' ',
(select BASI_510.DESCRICAO from BASI_510
where BASI_510.COD_TIPO_AVIAMENTO = BASI_030.COD_TIPO_AVIAMENTO
and BASI_510.SEQ_ATRIBUTO = 02
and BASI_510.COD_ATRIBUTO = BASI_030.COD_ATRIBUTO_02), ' ',
(select BASI_510.DESCRICAO from BASI_510
where BASI_510.COD_TIPO_AVIAMENTO = BASI_030.COD_TIPO_AVIAMENTO
and BASI_510.SEQ_ATRIBUTO = 03
and BASI_510.COD_ATRIBUTO = BASI_030.COD_ATRIBUTO_03), ' ',
(select BASI_510.DESCRICAO from BASI_510
where BASI_510.COD_TIPO_AVIAMENTO = BASI_030.COD_TIPO_AVIAMENTO
and BASI_510.SEQ_ATRIBUTO = 04
and BASI_510.COD_ATRIBUTO = BASI_030.COD_ATRIBUTO_04), ' ',
(select BASI_510.DESCRICAO from BASI_510
where BASI_510.COD_TIPO_AVIAMENTO = BASI_030.COD_TIPO_AVIAMENTO
and BASI_510.SEQ_ATRIBUTO = 05
and BASI_510.COD_ATRIBUTO = BASI_030.COD_ATRIBUTO_05), ' ',
(select BASI_510.DESCRICAO from BASI_510
where BASI_510.COD_TIPO_AVIAMENTO = BASI_030.COD_TIPO_AVIAMENTO
and BASI_510.SEQ_ATRIBUTO = 06
and BASI_510.COD_ATRIBUTO = BASI_030.COD_ATRIBUTO_06), ' ',
(select BASI_510.DESCRICAO from BASI_510
where BASI_510.COD_TIPO_AVIAMENTO = BASI_030.COD_TIPO_AVIAMENTO
and BASI_510.SEQ_ATRIBUTO = 07
and BASI_510.COD_ATRIBUTO = BASI_030.COD_ATRIBUTO_07), ' ',
(select BASI_510.DESCRICAO from BASI_510
where BASI_510.COD_TIPO_AVIAMENTO = BASI_030.COD_TIPO_AVIAMENTO
and BASI_510.SEQ_ATRIBUTO = 08
and BASI_510.COD_ATRIBUTO = BASI_030.COD_ATRIBUTO_08), ' ',
(select BASI_510.DESCRICAO from BASI_510
where BASI_510.COD_TIPO_AVIAMENTO = BASI_030.COD_TIPO_AVIAMENTO
and BASI_510.SEQ_ATRIBUTO = 09
and BASI_510.COD_ATRIBUTO = BASI_030.COD_ATRIBUTO_09), ' ',
(select BASI_510.DESCRICAO from BASI_510
where BASI_510.COD_TIPO_AVIAMENTO = BASI_030.COD_TIPO_AVIAMENTO
and BASI_510.SEQ_ATRIBUTO = 10
and BASI_510.COD_ATRIBUTO = BASI_030.COD_ATRIBUTO_10), ' ',
BASI_020.DESCR_TAM_REFER, ' ', BASI_010.DESCRICAO_15) as Descricao,
BASI_010.COMPLEMENTO
from BASI_010, BASI_020, BASI_030
where BASI_010.NIVEL_ESTRUTURA = '9'
' .$linha. '
and BASI_010.NIVEL_ESTRUTURA = BASI_020.BASI030_NIVEL030
and BASI_010.GRUPO_ESTRUTURA = BASI_020.BASI030_REFERENC
and BASI_010.SUBGRU_ESTRUTURA = BASI_020.TAMANHO_REF
and BASI_010.NIVEL_ESTRUTURA = BASI_030.NIVEL_ESTRUTURA
and BASI_010.GRUPO_ESTRUTURA = BASI_030.REFERENCIA
and BASI_030.COD_TIPO_AVIAMENTO is NOT NULL
order by
BASI_010.GRUPO_ESTRUTURA,
BASI_010.SUBGRU_ESTRUTURA,
BASI_010.ITEM_ESTRUTURA ";
This query fails in my php code, using myql_query, but works on command line.
Thanks.
