Cargando
$selImgBig = "SELECT i.name as image FROM images i WHERE type = 'carrousel' AND i.products_id = '".$_SESSION['id_urbanizacion']."'"; $queryImgBig=mysql_query($selImgBig, $conddbb); $resImgBig=mysql_fetch_assoc($queryImgBig); $cant_resImgBig=mysql_num_rows($queryImgBig); $arrImgs = ""; $count = 0; do{ if($count > 0) $arrImgs.= ",".$resImgBig['image']; else $arrImgs.= $resImgBig['image']; //array_push($arrImgs,$resImgBig['name']); $count++; }while($resImgBig=mysql_fetch_assoc($queryImgBig)); //echo count($arrImgs); //if($cant_resImgBig > 0) $s_img = "administrador/images/productos/big/".$resNot['image']; //else $s_img = "administrador/images/no_image.jpg"; ?>
Cargando
En echo $_SESSION['nombre']; ?>...
echo recortarCadena($_SESSION['descripcion'],450); ?>
Cargando
Cargando
Cargando
$selDest= "SELECT DISTINCT p.nombre, p.descripcion, p.precio, p.prod_id, c.nombre as nombre_categ, c.urlname FROM productos p LEFT JOIN categorias c ON c.categ_id = p.categ_id LEFT JOIN productos_urbanizaciones d ON p.prod_id = d.id_producto WHERE d.id_urbanizacion = '".$_SESSION['id_urbanizacion']."' AND destacado = '1' AND p.status = 'active' ORDER BY rand() LIMIT 2"; $queryDest=mysql_query($selDest, $conddbb); $resDest=mysql_fetch_assoc($queryDest); $cant_resDest=mysql_num_rows($queryDest); $arrDest = array(); do{ //IMAGENES // PHOTOS //////////////////////////////////////////////////////////////////// $strImg="SELECT * FROM images WHERE products_id = '".$resDest['prod_id']."' and table_name = 'productos' and type = 'destacada' LIMIT 0,1"; $qryImg=mysql_query($strImg, $conddbb); $resImg=mysql_fetch_assoc($qryImg); $cantImg=mysql_num_rows($qryImg); if($cantImg > 0) $img = "administrador/images/productos/big/".$resImg['name']; else $img = "administrador/images/productos/dest_no_image.jpg"; //DATOS $arrObj = array(); array_push($arrObj,$resDest['nombre'],$resDest['descripcion'],$resDest['nombre_categ'],$resDest['prod_id'],$resDest['precio'],$img,$resDest['urlname']); array_push($arrDest,$arrObj); }while($resDest=mysql_fetch_assoc($queryDest)); ?>
Otras opciones de alquiler muy cerca
echo "Urbanización ". $arrDest[0][2]."
".recortarCadena($arrDest[0][0],20);?>
echo recortarCadena($arrDest[0][1],140);?>
echo $arrDest[0][4] ;?>
[ Ver +]
echo "Urbanización ". $arrDest[1][2]."
".recortarCadena($arrDest[1][0],20);?>
echo recortarCadena($arrDest[1][1],140);?>
echo $arrDest[1][4] ;?>
[ Ver +]
include('footer.php'); ?>