jeudi 13 août 2015

REPORT TABLE: PHP and MYSQL

I am working on a report table(not a mysql table) where it displays the values of 3 different MySQL Tables. Here are the tables with their columns:

table.SERVICES

  • service_id
  • service_name

table.BILLING_ENTRY

  • billing_id

  • billin_patientname(customer)

  • billing_servicename

  • billing_serviceid

  • biliing_amount

table.BILLING

  • billing_id
  • billing_patientname(customer)

COLUMNS WITH THE SAME VALUE (table -- column)

  • services -- service_id == billing_entry -- billing_serviceid

  • billing_entry -- billing_id == billing -- billing_id

Below is the table that I am referring. The Services(table head) is the items form table.items

TABLE

At this moment, I really don't know how do the right PHP code of what I wanted. I hope anyone can provide a Native Code for this since I will be translating/converting it to CodeIgniter's way.I hope anyone can help me.

Best Regards



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire