get_results("SELECT * FROM prensa WHERE prensa.activo='Y' ORDER BY prensa.orden");
$resultados = $db->get_results("SELECT * FROM prereferencia INNER JOIN (SELECT * FROM prensa WHERE prensa.activo = 'Y') prensa ON (prereferencia.id_preRef = prensa.id_preRef) WHERE prereferencia.activo='Y' AND prensa.activo = 'Y' AND prereferencia.id_preRef='$idp' ORDER BY prensa.orden, prensa.id_prensa DESC");
$resnav = $db->get_results("SELECT DISTINCT * FROM prereferencia INNER JOIN (SELECT * FROM prensa WHERE prensa.activo = 'Y') prensa ON (prensa.id_preRef = prereferencia.id_preRef) WHERE prereferencia.activo='Y' AND prensa.activo = 'Y' GROUP BY prereferencia.id_preRef ORDER BY prereferencia.orden, prereferencia.id_preRef DESC ");
//
if(!$resultados){
header ('Location: prensa.php' );
}else{
?>
get_var("SELECT prereferencia.nombre FROM prereferencia WHERE prereferencia.id_preRef = '$ap->id_preRef' ");
?>
Tema:
get_var("SELECT prereferencia.nombre FROM prereferencia WHERE prereferencia.id_preRef = '$aip->id_preRef' ");
?>