define("DIR_UPLOAD_NOTICIAS", "uploads/mod_noticias/");
include "includes.php";
$query = " SELECT noticias.* FROM noticias WHERE noticias.activo = 1 order by orden";
$result = $id_conexion->query($query);
?>
Caida Libre // EVENTOS 360
NOTICIAS
if (mysqli_num_rows($result) > 0){?>
while ($row = mysqli_fetch_array($result)) {
$noticiaId = $row['id'];
$titulo = $row['titulo'];
$descripcion_corta = $row['descripcioncorta'];
$query_fotoPrincipal = " select foto_chica from fotosnoticias where noticiaId = $noticiaId and orden = 0";
$fotoPrincipal = "";
$result_fotoPrincipal = $id_conexion->query($query_fotoPrincipal);
if(mysqli_num_rows($result_fotoPrincipal) > 0){
$hay_fotos = true;
$row_fotoPrincipal = mysqli_fetch_array($result_fotoPrincipal);
$href_foto_chica = DIR_UPLOAD_NOTICIAS.$row_fotoPrincipal['foto_chica'];
$fotoPrincipal= "";
}else{
$fotoPrincipal= "";
}
?>