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_ANO ,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 ORDER BY 1,3,2"; $sth = ibase_query($dbh, $cmd); $cl=1; while ($row = ibase_fetch_object ($sth)) { if ($cl == 1) { ?>
VEIC_FOTO"?> width='88' heigth='60'">
echo "$row->MOD_DESCRICAO
$row->VEIC_MOTOR"?>
Ano: echo "$row->VEIC_ANO"?>
$cl = 2; } else { ?>
VEIC_FOTO"?> width='88' heigth='60'">
echo "$row->MOD_DESCRICAO
$row->VEIC_FOTO"?>
Ano: echo "$row->VEIC_ANO"?>
$cl = 1;} } ?>