help with horizontal display of query

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
fcastle
Forum Newbie
Posts: 1
Joined: Sun Oct 11, 2009 10:17 am

help with horizontal display of query

Post 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!
Post Reply