Matérias $categoria_tx";
#---------------- INICIO MONTANDO BREADCRUMB VERSAO 2 ---------------------#
$obj_tx_bread = new Principal;
$obj_tx_bread -> executa("select cod from cad_".$t1." where tit_url = '$tit' ");
$numRows_bread = $obj_tx_bread -> numRows();
if($numRows_bread > 0)
{
$row_tx_bread = $obj_tx_bread -> fetchArray();
$cod_bread = $row_tx_bread[0];
$i = substr($t1, -1);
$i = (int) $i;
if(!is_int($i) && ($i < 1 || $i > 3))
{
die();
}
for($i2 = $i; $i2>=0; $i2--)
{
$obj_tx_bread3 = new Principal;
if($i2 > 1)
{
$sql = "select cod_materia_sub".($i2-1)." as cod_mat, cad_materia_sub".$i2.".tx as tx_mat from
cad_materia_sub".$i2." inner join cruza_materia_sub".($i2-1)."_materia_sub".$i2."
on cad_materia_sub".$i2.".cod = cruza_materia_sub".($i2-1)."_materia_sub".$i2.".cod_materia_sub".$i2."
where cruza_materia_sub".($i2-1)."_materia_sub".$i2.".cod_materia_sub".$i2." = '$cod_bread' ";
}
else if($i2 == 1 && $i > 0)
{
$sql = "select cod_materia as cod_mat, cad_materia_sub".$i2.".tx as tx_mat from
cad_materia_sub".$i2." inner join cruza_materia_materia_sub".$i2."
on cad_materia_sub".$i2.".cod = cruza_materia_materia_sub".$i2.".cod_materia_sub".$i2."
where cruza_materia_materia_sub".$i2.".cod_materia_sub".$i2." = '$cod_bread' ";
}
else
{
$sql = "select tx as tx_mat from cad_materia where cod = '$cod_bread' ";
}
$obj_tx_bread3 -> executa($sql);
$row_tx_bread3 = $obj_tx_bread3 -> fetchArray();
$cod_bread = $row_tx_bread3[cod_mat];
$space = $i2 > 0 ? ' > ' : '';
if($i2 == 0)
{
$breadcrumb = $space."
".$row_tx_bread3[tx_mat]."".$breadcrumb;
}
else
{
$breadcrumb = $space."
".$row_tx_bread3[tx_mat]."".$breadcrumb;
}
unset($sql, $obj_tx_bread3, $space);
}
}
$obj_tx = new Titulo;
$obj_tx -> cx_tit_azul("$breadcrumb");
#---------------- FIM MONTANDO BREADCRUMB VERSAO 2 ---------------------#
$obj = new Principal;
$obj -> executa("select tx, tx_".$categoria." from cad_".$t1." where tit_url ='$tit' ");
$row = $obj -> fetchArray();
$tx_pagina = $row["tx_".$categoria];
echo "
$tx_pagina
";
include('inc/sql_menu.php');
echo "
$materia
";
?>