Hey guys,
It would be helpful to hear a suggestion on how to present some data in a page.
I have 3 database tables , Orders, Shipments and Payments
I would like to list them (ordered by date) in a way like the picture below:
The fields in picture are the fields I need (and they are already part of each table’s schema…
The way I’m thinking of working is:
- Pull the data from each table ordered by date
- Assign these values to an Array
- Present the Array’s data in my page
(Just in case, we are talking about 10-15 records maximum in total)
If not an Array then which could be the way to solve it?
I do not ask for the exact way to build this structure, but only the way to process in order the page not to be slow and resource/traffic effective.
Any suggestion or idea would be much appreciated!
wappler 5.6
PHP
Mysql
Thanks in advance
Tasos