connect_errno) {
echo "NO CONECTION: (" . $connect->connect_errno . ") " . $connect->connect_error;
}
$query = "SELECT n.id, n.tapa,n.seccion_id,CAST(CONVERT(n.titulo USING utf8) AS binary) as titulo,CAST(CONVERT(n.copete USING utf8) AS binary) as copete,CAST(CONVERT(n.texto USING utf8) AS binary) as texto,n.imagen,n.audio,n.video,DATE_FORMAT(n.fecha_publicacion,'%d/%m/%Y') as fecha_publicacion,s.area,n.seccion_id, (SELECT GROUP_CONCAT(noticias_newweb_media.patch SEPARATOR '|') as pic FROM noticias_newweb_media WHERE noticias_newweb_media.newsid=n.id ORDER BY n.shortNota ASC LIMIT 0,1) as patch, s.titulo as seccion_title FROM noticias_newweb n LEFT JOIN noticias_seccion s ON (s.id=n.seccion_id) WHERE n.id=" . $id . " AND n.autorizado='1' LIMIT 0,1;";
$result = $connect->query($query);
$row = $result->fetch_assoc();
echo '
' . $row["titulo"] . '
';
echo '';
$link = 'https://misionesweb.com/show/index.php?noticia=' . $id . '&act=compart';
if ($_GET["ver"]) {
$hed = 'Location: ' . $link;
header($hed);
} else {
echo '
' . $row["titulo"] . '
';
echo '';
}
}
}