As part of an airshow web site we'd like to know where our visitors came from. So, when people buy tickets we'll ask what their zipcode is and also record how many adults/ children/ toddlers tickets were sold to the party. The result will be a MySQL table containing the following columns Zip, City/St, Adults, Children, Toddlers. CitySt will be looked up when the ticket seller enters the zipcode and stored in the table.
I'd like to display a table sorted by CitySt with separate columns showing how many adults/ children/ toddlers came from each CitySt, I only want to show the totals by CitySt and not the individual sales. i can do the details but how do I create the table showing summary info only by CitySt. Something like this
| Header 1 | Header 2 | Header 3 | Header 4 |
|---|
| City ST | Adults | Children | Toddlers |
| City 1 | 12 | 4 | 2 |
| City 2 | 8 | 10 | 4 |
| City 3 | 10 | 6 | 0 |
I can display the individual table rows but how do I display just summary info by city?
Thanks,
Tony
