trconsulting
asked on
PHP MYSQL Need to creat a table from four queries arrays into one table to manipulate the results.
How do I create a table of values(arrays) from 4 queries.
I have a table of rooms in a building with different fields one is a rm_type code. I use this code in three different queries to sort the rooms by codes...Code A code b code c. I then sum the area field and sort by floor. Works great i get three arrays that I can manipulate.
The 4th query is from a different table it has a list of building and floors and area of each. I query by building and get the array of each floors area. Works great.
What I need to do is get the arrays into one table so I can get a results of adding the first three queries together and subtracting them from the 4th query.
I can do it with out the 5 table but each building has differant number of florrs so I need to do a loop or something so I can publish it on a web site
I have a table of rooms in a building with different fields one is a rm_type code. I use this code in three different queries to sort the rooms by codes...Code A code b code c. I then sum the area field and sort by floor. Works great i get three arrays that I can manipulate.
The 4th query is from a different table it has a list of building and floors and area of each. I query by building and get the array of each floors area. Works great.
What I need to do is get the arrays into one table so I can get a results of adding the first three queries together and subtracting them from the 4th query.
I can do it with out the 5 table but each building has differant number of florrs so I need to do a loop or something so I can publish it on a web site
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.