Page 1 of 1

help with horizontal display of query

Posted: Sun Oct 11, 2009 10:21 am
by fcastle
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!