include "php/rutinas.php"; ?> $hoy = date ( "Y-m-d" , time() ); ?> $sql03 = "SELECT * FROM foto_home WHERE activo=1 ORDER BY RAND() LIMIT 0, 10"; $result03 = mysql_query($sql03, $conn); $thumbs = ""; while($fila03 = mysql_fetch_array($result03)) { $thumbs .= $fila03["id"].', '; } $thumbs = substr($thumbs,0,strlen($thumbs)-2); $fotoscolecciones = ""; $fotosfotografos = ""; $fotostitulo = ""; $sql = "SELECT * FROM colecciones WHERE activotour=1 AND fecha <= '".$hoy."' GROUP BY modelo ORDER BY RAND()"; $result = mysql_query($sql, $conn); while($fila = mysql_fetch_array($result)) { if(file_exists("public/ficheros/galerias/coleccion".$fila["id"]."/tourcoleccion1.jpg")) { $fotoscolecciones.= "http://www.nenablue.com/public/ficheros/galerias/coleccion". $fila['id'] ."/tourcoleccion1.jpg"."¬"; $fotostitulo.= $fila['tituloEn']."¬"; mysql_close($conn); ?>
|
|