"; print ""; print ""; // COLUMNA DCHA print "
"; switch ($tema) { case NULL: $tema2 = "!='Cine'"; $sufijo = "todo"; break; case "bd": $tema2 = "='Blu-Ray'"; $tema3 = "Blu-Ray"; $sufijo = "bd"; break; case "hd": $tema2 = "='HD-DVD'"; $tema3 = "HD-DVD"; $sufijo = "hd"; break; case "dvd": $tema2 = "='DVD Video'"; $tema3 = "DVD"; $sufijo = "dvd"; break; case "alquiler": $tema2 = "='Alquiler'"; $tema3 = "DVD alquiler"; $sufijo = "alquiler"; break; case "cine": $tema2 = "='Cine'"; $tema3 = "Cine"; $formato = "Cine"; $sufijo = "cine"; break; default: $tema2 = "!='Cine'"; $sufijo = "todo"; } include ("bloques/navigation.php"); print ""; print "
"; // --> PUBLICIDAD SUPERIOR include ("google/publicidad2.html"); if ($busqueda==NULL) { $busqueda = date("Ym"); } if ($formato!='Cine') { $test->sql = "SELECT * FROM prueba WHERE (formato$tema2 AND titulo LIKE '%$busqueda%') or (formato$tema2 AND distribuidora LIKE '%$busqueda%') or (formato$tema2 AND director LIKE '%$busqueda%') or (formato$tema2 AND interpretes LIKE '%$busqueda%') or (formato$tema2 AND fecha LIKE '%$busqueda%') and promocion='SPA' and fallo LIKE '%$fallo%' and tipo LIKE '%$tipo%' and hot LIKE '%$hot%' ORDER BY fecha, distribuidora, titulo"; } else { $test->sql = "SELECT * FROM prueba WHERE (formato='Cine' AND titulo LIKE '%$busqueda%') or (formato='Cine' AND distribuidora LIKE '%$busqueda%') or (formato='Cine' AND director LIKE '%$busqueda%') or (formato='Cine' AND interpretes LIKE '%$busqueda%') or (formato='Cine' AND fechacine LIKE '%$busqueda%') and promocion='SPA' and fallo LIKE '%$fallo%' and tipo LIKE '%$tipo%' and hot LIKE '%$hot%' ORDER BY fechacine, distribuidora, titulo"; } $result = $test->get_page_result(); // result set $num_rows = $test->get_page_num_rows(); // number of records in result set $nav_links = $test->navigation(" | ", "currentStyle"); // the navigation links (define a CSS class selector for the current link) $nav_info = $test->page_info("to"); // information about the number of records on page ("to" is the text between the number) $simple_nav_links = $test->back_forward_link(true); // the navigation with only the back and forward links, use true to use images $total_recs = $test->get_total_rows(); // the total number of records print "
"; for ($i = 0; $i < $num_rows; $i++) { $titulo = mysql_result($result, $i, "titulo"); $id = mysql_result($result, $i, "id"); $dvdgo = mysql_result($result, $i, "dvdgo"); $imdb = mysql_result($result, $i, "imdb"); $distribuidora = mysql_result($result, $i, "distribuidora"); $hot = mysql_result($result, $i, "hot"); $ficha = mysql_result($result, $i, "ficha"); $caratuladelante = mysql_result($result, $i, "caratuladelante"); $caratuladetras = mysql_result($result, $i, "caratuladetras"); $formato = mysql_result($result, $i, "formato"); $tipo = mysql_result($result, $i, "tipo"); $corregir = mysql_result($result, $i, "corregir"); $fnac = mysql_result($result, $i, "fnac"); $fallo = mysql_result($result, $i, "fallo"); $fecha = mysql_result($result, $i, "fecha"); $dia = mysql_result($result, $i, "dia"); $mes = mysql_result($result, $i, "mes"); $alanzamiento = mysql_result($result, $i, "alanzamiento"); $fechacine = mysql_result($result, $i, "fechacine"); $diacine = mysql_result($result, $i, "diacine"); $mescine = mysql_result($result, $i, "mescine"); $alanzamientocine = mysql_result($result, $i, "alanzamientocine"); $numdiscos = mysql_result($result, $i, "numdiscos"); $urloficial = mysql_result($result, $i, "urloficial"); $allposters = mysql_result($result, $i, "allposters"); $bsofnac = mysql_result($result, $i, "bsofnac"); $foromundodvd = mysql_result($result, $i, "foromundodvd"); $forodvd = mysql_result($result, $i, "forodvd"); $trailer = mysql_result($result, $i, "trailer"); $imdb = mysql_result($result, $i, "imdb"); $calificacion = mysql_result($result, $i, "calificacion"); $idiomas = mysql_result($result, $i, "idiomas"); $director = mysql_result($result, $i, "director"); $creador = mysql_result($result, $i, "creador"); $formatocine = mysql_result($result, $i, "formatocine"); $duracion = mysql_result($result, $i, "duracion"); $nacionalidad = mysql_result($result, $i, "nacionalidad"); $color = mysql_result($result, $i, "color"); $interpretes = mysql_result($result, $i, "interpretes"); $aestreno = mysql_result($result, $i, "aestreno"); $original = mysql_result($result, $i, "original"); $genero = mysql_result($result, $i, "genero"); $comentarios = mysql_result($result, $i, "comentarios"); include("urls.php"); $fechahoy = date("Ymd"); if ($formato!='Cine') { $estemes = "$alanzamiento$mes"; print ""; } print "
"; include ("bloques/fechanavigation_p1.php"); include ("bloques/fecha.php"); // print ""; $fechaanterior = $fecha; } else { $estemes = "$alanzamientocine$mescine"; print "
"; include ("bloques/fechanavigationcine_p1.php"); include ("bloques/fechacine.php"); // print ""; $fechaanterior = $fechacine; } switch ($formato) { case "Cine": $fcolor = "cine"; break; case "Alquiler": $fcolor = "alquiler"; break; case "DVD Video": $fcolor = "dvd"; break; case "Blu-Ray": $fcolor = "bd"; break; } print "
"; print "
"; if ($formato=='Blu-Ray') { if ($ficha=='SI') { print "$titulo $formato"; } else { print "$titulo $formato"; } } else { if ($ficha=='SI') { print "$titulo $formato"; } else { print "$titulo $formato"; } } print ""; if ($ficha=='SI') { print "$titulo"; } else { print "$titulo"; } if ($director) { print "
"; print "$director"; } if ($distribuidora) { print "
"; print "$distribuidora"; } print "
"; if ($formato=="Cine") { print "En cines:
$diacine-$mescine-$alanzamientocine
"; } else { if ($fechahoy<$fecha) { print "Sale a la venta:
$dia-$mes-$alanzamiento
"; } else { print "Disponible desde:
$dia-$mes-$alanzamiento
"; } print "
"; if ($fnac) { print "fnac"; } if ($dvdgo) { print " / dvdgo"; } } print "
"; print "
"; print "
"; // SEPARACIÓN ENTRE EL SISTEMA DE PÁGINAS Y LA TABLA DE RESULTADOS print ""; print ""; print "
"; include ("google/google_728x015f.html"); print "
".$nav_links."
"; $test->free_page_result(); print "

"; include ("bloques/navigation2.php"); print "
"; print ""; ?>