INNER JOIN sys_comprobante ON sys_comprobante.id_turno = tur.id_tur INNER JOIN sys_comprobante_detalle ON sys_comprobante_detalle.idcomprobante = sys_comprobante.idcomprobante INNER JOIN pro on pro.id_pro = sys_comprobante_detalle.idproducto WHERE tur.est_tur = '".$est."' AND (sys_comprobante_detalle.mostrar = 1 or pro.bar = 0) AND tur.nro = '".$_POST['id_hab']."'; "; $result = mysql_query($sql, $pconnect); while($fila = mysql_fetch_assoc($result)){ $total_turno = $fila['total']; $idcomprobante = $fila['idcomprobante']; $fec_in = $fila_comp['fec_in']; } // calculamos el dia y la hora para la fecha de entrada $dia_act = traer_dia_producto($fec_in); $hor_act = traer_hora_producto($fec_in); // obtenemos el precio original $sql = " SELECT pro.val FROM tur INNER JOIN hab ON hab.nro = tur.nro INNER JOIN pro ON pro.tip = hab.tip WHERE tur.est_tur = 1 AND tur.nro = '".$_POST['id_hab']."' AND pro.bar = 0 AND pro.promo_hab = 0 AND pro.dia = '".$dia_act."' AND pro.hor = '".$hor_act."' LIMIT 1 ";
</head> <body> <div> <div style="float:left;"> <img src="img/logo_cb.png" width="100%" /> </div> <div style="float:left;"> <!--<img src="img/hab_cb.png" width="100%" />--> </div> <div style="clear:both;"></div> </div> <? $dia_producto = traer_dia_producto(); $hora_producto = traer_hora_producto(); $sql = " SELECT pro.tip, tip_hab.tip, pro.pro, pro.val, pro.tie FROM pro INNER JOIN tip_hab ON tip_hab.id_tip = pro.tip WHERE pro.bar = 0 AND pro.dia = ".$dia_producto." AND pro.hor = ".$hora_producto." "; $result = mysql_query($sql, $pconnect); //echo "mysql_error: ".mysql_error(); ?> <div id="contenedor"> <? $contar = 0;