$id_noticia = $_GET["id"]; $query = "SELECT noticias.mostrar_destacado AS destacada, noticias.id_noticia AS id_noticia, noticias.titular AS titular, noticias_cuerpo.cuerpo AS cuerpo, noticias_volanta.volanta AS volanta, noticias_copete.copete AS copete, noticias_img.url AS img, noticias_epigrafe.epigrafe AS epigrafe FROM noticias INNER JOIN noticias_cuerpo ON noticias.id_noticia = noticias_cuerpo.id_noticia LEFT JOIN noticias_volanta ON noticias.id_noticia = noticias_volanta.id_noticia LEFT JOIN noticias_copete ON noticias.id_noticia = noticias_copete.id_noticia LEFT JOIN noticias_epigrafe ON noticias.id_noticia = noticias_epigrafe.id_noticia LEFT JOIN noticias_img ON noticias.id_noticia = noticias_img.id_noticia WHERE noticias.id_noticia = " . $id_noticia; $rs = mysql_query($query, $link); if (mysql_num_rows($rs) < 1) { $url = "/index.php"; header("Location: $url"); } else { extract(mysql_fetch_array($rs)); } ?>