Advertisement
Guest User

Untitled

a guest
Jun 25th, 2019
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.97 KB | None | 0 0
  1. <?php
  2.  
  3. $query="SELECT TMedicamentos.Presentacion, TMedicamentos.Descripcion, MDrogasTP.Descripcion, TAccionTera.DescAccTera, TLaboratorio.Descripcion, RVadMedPlan.Porc_Dto FROM TMedicamentos
  4. INNER JOIN MDrogasTP ON TMedicamentos.Cod_Droga = MDrogasTP.CodigoDrogasTP
  5. INNER JOIN TAccionTera ON MDrogasTP.CodAccTera = TAccionTera.CodAccTera
  6. INNER JOIN TLaboratorio ON TMedicamentos.Cod_Laboratorio = TLaboratorio.Cod_Laboratorio
  7. INNER JOIN RVadMedPlan ON TMedicamentos.CodNum = RVadMedPlan.CodNum";
  8.  
  9. $consulta=$conexion->query($query);
  10. while ($fila=$consulta->fetch(PDO::FETCH_ASSOC))
  11. {
  12. echo'
  13. <tr>
  14. <td>'.$fila['Descripcion'].'</td>
  15. <td>'.$fila['Descripcion'].'</td>
  16. <td>'.$fila['Descripcion'].'</td>
  17. <td>'.$fila['DescAccTera'].'</td>
  18. <td>'.$fila['Presentacion'].'</td>
  19. <td>'.$fila['Porc_Dto'].'</td>
  20. </tr>
  21. ';
  22. }
  23.  
  24. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement