Move around the city and don't miss a thing!

Date

J'adore Mtl
[email protected] free support**
Live the city to the fullest

Visit Montreal's most iconic sights!

prepare('SELECT * FROM anunciosh WHERE fechaf > :Fecha AND turno = 0 ORDER BY RAND() LIMIT 0,1'); $sql->execute(array(':Fecha' => $main)); $result = $sql->fetchAll(); $numero = count($result); if ($numero < 1){ $sqlid = "UPDATE anunciosh SET turno=0 WHERE 1"; $esid = $db->prepare($sqlid); $esid->execute(); }else{ $i++; foreach ($result as $Rs) { $matrizclick[$cont]=$Rs["registro"]; $matrizimg[$cont]=$Rs["imagen"].$lang.".jpg"; $cont++; $numid=$Rs["registro"]; $sqla = $db->prepare("INSERT INTO impresionesh (registro, fecha, pagina ) VALUES (:Reg, :Fechaa, :Paginaa)"); $sqla->bindParam(':Reg', $numid); $sqla->bindParam(':Fechaa', $hoy); $sqla->bindParam(':Paginaa', $pags); $sqla->execute(); $sqlid = "UPDATE anunciosh SET reloj=reloj+1, turno=1 WHERE registro = :Aupd"; $esid = $db->prepare($sqlid); $esid->execute(array(':Aupd' => $numid)); } } } ?>
prepare('SELECT * FROM anunciosh WHERE fechaf > :Fecha AND turno = 0 ORDER BY RAND() LIMIT 0,1'); $sql->execute(array(':Fecha' => $main)); $result = $sql->fetchAll(); $numero = count($result); if ($numero < 1){ $sqlid = "UPDATE anunciosh SET turno=0 WHERE 1"; $esid = $db->prepare($sqlid); $esid->execute(); }else{ $i++; foreach ($result as $Rs) { $matrizclick[$cont]=$Rs["registro"]; $matrizimg[$cont]=$Rs["imagen"].$lang.".jpg"; $cont++; $numid=$Rs["registro"]; $sqla = $db->prepare("INSERT INTO impresionesh (registro, fecha, pagina ) VALUES (:Reg, :Fechaa, :Paginaa)"); $sqla->bindParam(':Reg', $numid); $sqla->bindParam(':Fechaa', $hoy); $sqla->bindParam(':Paginaa', $pags); $sqla->execute(); $sqlid = "UPDATE anunciosh SET reloj=reloj+1, turno=1 WHERE registro = :Aupd"; $esid = $db->prepare($sqlid); $esid->execute(array(':Aupd' => $numid)); } } } ?>
prepare('SELECT * FROM anunciosh WHERE fechaf > :Fecha AND turno = 0 ORDER BY RAND() LIMIT 0,1'); $sql->execute(array(':Fecha' => $main)); $result = $sql->fetchAll(); $numero = count($result); if ($numero < 1){ $sqlid = "UPDATE anunciosh SET turno=0 WHERE 1"; $esid = $db->prepare($sqlid); $esid->execute(); }else{ $i++; foreach ($result as $Rs) { $matrizclick[$cont]=$Rs["registro"]; $matrizimg[$cont]=$Rs["imagen"].$lang.".jpg"; $cont++; $numid=$Rs["registro"]; $sqla = $db->prepare("INSERT INTO impresionesh (registro, fecha, pagina ) VALUES (:Reg, :Fechaa, :Paginaa)"); $sqla->bindParam(':Reg', $numid); $sqla->bindParam(':Fechaa', $hoy); $sqla->bindParam(':Paginaa', $pags); $sqla->execute(); $sqlid = "UPDATE anunciosh SET reloj=reloj+1, turno=1 WHERE registro = :Aupd"; $esid = $db->prepare($sqlid); $esid->execute(array(':Aupd' => $numid)); } } } ?>
prepare('SELECT * FROM anunciosh WHERE fechaf > :Fecha AND turno = 0 ORDER BY RAND() LIMIT 0,1'); $sql->execute(array(':Fecha' => $main)); $result = $sql->fetchAll(); $numero = count($result); if ($numero < 1){ $sqlid = "UPDATE anunciosh SET turno=0 WHERE 1"; $esid = $db->prepare($sqlid); $esid->execute(); }else{ $i++; foreach ($result as $Rs) { $matrizclick[$cont]=$Rs["registro"]; $matrizimg[$cont]=$Rs["imagen"].$lang.".jpg"; $cont++; $numid=$Rs["registro"]; $sqla = $db->prepare("INSERT INTO impresionesh (registro, fecha, pagina ) VALUES (:Reg, :Fechaa, :Paginaa)"); $sqla->bindParam(':Reg', $numid); $sqla->bindParam(':Fechaa', $hoy); $sqla->bindParam(':Paginaa', $pags); $sqla->execute(); $sqlid = "UPDATE anunciosh SET reloj=reloj+1, turno=1 WHERE registro = :Aupd"; $esid = $db->prepare($sqlid); $esid->execute(array(':Aupd' => $numid)); } } } ?>