help with horizontal display of query
Posted: Sun Oct 11, 2009 10:21 am
hello.. i generate a php/mysql vertical table with results for reports of a "CUSTOMER SERVICE OFFICE" reporting visits, reasons for visit, etc...like this...
CUSTOMER SERVICE OFFICE (1)
Total visits : 120
Tourism: 40
Pleasure: 30
Business: 50
each one of this values comes from a query that only changes the id of the customer office...1, 2 , 3 ETC..
how can this table display this same information but for all the 5 point of customer service offices horizontally along with the results of the query in one single screen like this?
Query/office OFFICE (1) OFFICE (2)
Total visits 120 | 100
Tourism: 40 | 50
Pleasure: 30 | 40
Business: 50 | 10
is this possible?? any help would be really appreciated....
thanks!
CUSTOMER SERVICE OFFICE (1)
Total visits : 120
Tourism: 40
Pleasure: 30
Business: 50
each one of this values comes from a query that only changes the id of the customer office...1, 2 , 3 ETC..
how can this table display this same information but for all the 5 point of customer service offices horizontally along with the results of the query in one single screen like this?
Query/office OFFICE (1) OFFICE (2)
Total visits 120 | 100
Tourism: 40 | 50
Pleasure: 30 | 40
Business: 50 | 10
is this possible?? any help would be really appreciated....
thanks!