Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $query="SELECT TMedicamentos.Presentacion, TMedicamentos.Descripcion, MDrogasTP.Descripcion, TAccionTera.DescAccTera, TLaboratorio.Descripcion, RVadMedPlan.Porc_Dto FROM TMedicamentos
- INNER JOIN MDrogasTP ON TMedicamentos.Cod_Droga = MDrogasTP.CodigoDrogasTP
- INNER JOIN TAccionTera ON MDrogasTP.CodAccTera = TAccionTera.CodAccTera
- INNER JOIN TLaboratorio ON TMedicamentos.Cod_Laboratorio = TLaboratorio.Cod_Laboratorio
- INNER JOIN RVadMedPlan ON TMedicamentos.CodNum = RVadMedPlan.CodNum";
- $consulta=$conexion->query($query);
- while ($fila=$consulta->fetch(PDO::FETCH_ASSOC))
- {
- echo'
- <tr>
- <td>'.$fila['Descripcion'].'</td>
- <td>'.$fila['Descripcion'].'</td>
- <td>'.$fila['Descripcion'].'</td>
- <td>'.$fila['DescAccTera'].'</td>
- <td>'.$fila['Presentacion'].'</td>
- <td>'.$fila['Porc_Dto'].'</td>
- </tr>
- ';
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement