text-decoration: none; } a:hover { color: #FC0; text-decoration: underline; } a:active { color: white; text-decoration: none; } a:link { text-decoration: none; } </style> <? $datos=$db->extraer("select * from tip_hab where act=1 ORDER BY orden_entrada"); ?> <table width="90%" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td width="40%"> </td> <td width="30%"><strong>Promo</strong></td> <td width="30%"><strong>Sin Promo</strong></td> </tr> <? foreach($datos as $dt){ $id=$dt['id_tip']; $tipo=$dt['tip']; $sql="select *,concat(hour(tie),'.',minute(tie)) as tiempo from pro INNER JOIN tip_hab ON pro.tip=tip_hab.id_tip where dia=$dia and hor=$hora and tip_hab.id_tip=$id";
/* CASE dia WHEN 1 THEN 'LUN A JUEV' WHEN 2 THEN 'VIE Y SAB' WHEN 3 THEN 'DOMINGO' END AS dia_lis, CASE hor WHEN 1 THEN '8 A 14 HS' WHEN 2 THEN '14 A 8 HS' WHEN 3 THEN '00 A 8 HS' END AS hor_lis */ $sql="select *,concat(hour(tie),'.',minute(tie)) as tiempo from pro where dia=$dia and hor=$hora"; $hab=$db->extraer($sql); $i=1; foreach($hab as $a){ if ($a['promo_hab']==1){ if ($i<>1){echo '&';} echo 'varPromo_'.$a['tip'].'='.$a['tiempo']."hs $".$a['val']; }else{ if ($i<>1){echo '&';} echo 'varOriginal_'.$a['tip'].'='.$a['tiempo']."hs $".$a['val']; } $i++; }