$id = Url::getURL(3);
$spoter = Url::getURL(1);
if ($id == ""){
?>
Media Partner
$res=DB::Select("select * from media_partner
where ((select count(*) from conteudos_informacao where conteudos_informacao_media_partner_codigo = media_partner_codigo)>0)
order by media_partner_codigo desc
");
while($media_partner = mysqli_fetch_array($res, MYSQLI_ASSOC))
{
?>
}?>
}
else
{
$res30=DB::Select("
select * from media_partner
where
media_partner_codigo = $id
");
$sp = mysqli_fetch_array($res30, MYSQLI_ASSOC);
?>
$res=DB::Select("select * from conteudos_informacao
where conteudos_informacao_media_partner_codigo = $id");
while($conteudos_informacao = mysqli_fetch_array($res, MYSQLI_ASSOC))
{
?>
}?>
}?>
}?>
}?>
}?>
}?>
$res=DB::Select("select * from media_partner where media_partner_codigo > $id
and
((select count(*) from conteudos_informacao where conteudos_informacao_media_partner_codigo = media_partner_codigo)>0)
order by media_partner_codigo asc limit 1
");
$media_partner_anterior = mysqli_fetch_array($res, MYSQLI_ASSOC);
if($media_partner_anterior['media_partner_descritivo']==""){
$mostra_anterior="display:none;";
}
else{
$mostra_anterior="display:block;";
}
?>
$res=DB::Select("select * from media_partner where media_partner_codigo < $id
and
((select count(*) from conteudos_informacao where conteudos_informacao_media_partner_codigo = media_partner_codigo)>0)
order by media_partner_codigo desc limit 1
");
$media_partner_seguinte = mysqli_fetch_array($res, MYSQLI_ASSOC);
if($media_partner_seguinte['media_partner_descritivo']==""){
$mostra_seguinte="display:none;";
}
else{
$mostra_seguinte="display:block;";
}
?>