now() order by orden asc";
$result = mysqli_query($cnx, $select);
if (mysqli_num_rows($result)!=0 ){
while ($row=mysqli_fetch_array($result)){
$select2 = "update banners_orden set orden = ".$orden." where id = ".$row["id"];
$result2 = mysqli_query($cnx,$select2);
$orden ++;
}
}
$select = "select * from banners_orden where turno = 'si'";
$result = mysqli_query($cnx, $select);
if (mysqli_num_rows($result)==0 ){
$select2 = "update banners_orden set turno = 'si' where orden = 1 ";
$result2 = mysqli_query($cnx,$select2);
}
$select = "select * from banners_orden order by orden asc";
$result = mysqli_query($cnx, $select);
$total_banners = mysqli_num_rows($result);
$id_banner_mostrar = 0;
$encon = "no";
$orden = 1;
if (mysqli_num_rows($result)!=0 ){
while ($row=mysqli_fetch_array($result)){
if ($row["turno"] == "si" && $encon == "no"){
$encon = "si";
if ($row["orden"] == $total_banners){
$orden = 1;
}else{
$orden = $row["orden"]+1;
}
}
}
$select2 = "update banners_orden set turno = 'no'";
$result2 = mysqli_query($cnx,$select2);
$select2 = "update banners_orden set turno = 'si' where orden = ".$orden;
$result2 = mysqli_query($cnx,$select2);
}
//echo $orden;
$select = "select * from banners_orden where turno = 'si'";
$result = mysqli_query($cnx, $select);
if (mysqli_num_rows($result)!=0 ){
while ($row=mysqli_fetch_array($result)){
$id_banner_mostrar = $row["id_banner"];
}
}
$select = "select * from banners where tipo = '".$_REQUEST["tipo"]."' and activo = 'si' and fecha_desde <= '$hoy' and fecha_hasta >= '$hoy' order by rand() limit 1";
$result = mysqli_query($cnx, $select);
if ($_REQUEST["master"]==1){
echo $select;
}
$encuentro = 0;
if (mysqli_num_rows($result)!=0 ){
while ($row=mysqli_fetch_array($result)){
$encuentro = 1;
$ancho = "";
if ($_REQUEST["ancho"] != ""){
$ancho = $_REQUEST["ancho"];
}
$select2 = "update banners set veces = veces + 1 where id = ".$row["id"];
$result2 = mysqli_query($cnx,$select2);
if ($row["url"] != "#"){
?>![]()
width="" alt="" src="/img/banners/" border="0" />![]()
width="" src="/img/banners/" border="0" />";
}
?>