include 'conexao.php'; $dbh = ibase_connect("$p_dir", "$p_login", "$p_senha"); $cmd = "SELECT VEIC_ID ,VEIC_MOD_ID ,VEIC_MARC_ID ,VEIC_DESCRICAO ,VEIC_FOTO ,VEIC_FOTO2 ,VEIC_FOTO3 ,VEIC_KM ,VEIC_COMB ,VEIC_ANO ,VEIC_MODELO ,VEIC_COR ,VEIC_VALOR ,VEIC_MOTOR ,MARC_DESCRICAO ,MOD_DESCRICAO FROM VEICULO V ,MODELO MO ,MARCA MA WHERE V.VEIC_MARC_ID = MO.MOD_MARC_ID AND V.VEIC_MOD_ID = MO.MOD_ID AND V.VEIC_MARC_ID = MA.MARC_ID AND MO.MOD_MARC_ID = MA.MARC_ID AND V.VEIC_ID = $cod AND MO.MOD_MARC_ID = $marc AND MO.MOD_ID = $mod "; $sth = ibase_query($dbh, $cmd); while ($row = ibase_fetch_object ($sth)) { $desc = $row->VEIC_DESCRICAO; $mod1 = $row->MOD_DESCRICAO; $marc1 = $row->MARC_DESCRICAO; $ano = $row->VEIC_ANO; $modelo= $row->VEIC_MODELO; $cor = $row->VEIC_COR; $valor = $row->VEIC_VALOR; $foto = $row->VEIC_FOTO; $foto2 = $row->VEIC_FOTO2; $foto3 = $row->VEIC_FOTO3; $km = $row->VEIC_KM; $comb = $row->VEIC_COMB; $motor = $row->VEIC_MOTOR; } ?>