Does MySQL support using the GROUP BY clause or any other mechanism to insert page or section breaks in query outputs? I'm trying to turn something like this:
[tt]+--------------------------------------------------+------------------+
| name | type |
+--------------------------------------------------+------------------+
| Dallas National, Dallas | 18-hole Private |
| Colonial Country Club, Fort Worth | 18-hole Private |
| Brook Hollow Golf Club, Dallas | 18-hole Private |
| Crown Colony Country Club, Lufkin | 18-hole Public |
| Tour 18, Flower Mound | 18-hole Public |
| Squaw Valley, Comanche Lakes, Glen Rose | 18-hole Public |
| Starr Hollow, Tolar | 9-hole Courses |
| Magnolia Ridge CC, Liberty | 9-hole Courses |
| Stewart Peninsula, The Colony | 9-hole Courses |
+--------------------------------------------------+------------------+[/tt]
Into something like this:
[tt]+------------------------------------------+
|18-hole Private |
+------------------------------------------+
|Dallas National, Dallas |
|Colonial Country Club, Fort Worth |
|Brook Hollow Golf Club, Dallas |
+------------------------------------------+
+------------------------------------------+
|18-hole Public |
+------------------------------------------+
|Crown Colony Country Club, Lufkin |
|Tour 18, Flower Mound |
|Squaw Valley, Comanche Lakes, Glen Rose |
+------------------------------------------+
+------------------------------------------+
|9-hole Courses |
+------------------------------------------+
|Starr Hollow, Tolar |
|Magnolia Ridge CC, Liberty |
|Stewart Peninsula, The Colony |
+------------------------------------------+[/tt]
Without having to use a procedural language.
Help?
Tia.
[tt]+--------------------------------------------------+------------------+
| name | type |
+--------------------------------------------------+------------------+
| Dallas National, Dallas | 18-hole Private |
| Colonial Country Club, Fort Worth | 18-hole Private |
| Brook Hollow Golf Club, Dallas | 18-hole Private |
| Crown Colony Country Club, Lufkin | 18-hole Public |
| Tour 18, Flower Mound | 18-hole Public |
| Squaw Valley, Comanche Lakes, Glen Rose | 18-hole Public |
| Starr Hollow, Tolar | 9-hole Courses |
| Magnolia Ridge CC, Liberty | 9-hole Courses |
| Stewart Peninsula, The Colony | 9-hole Courses |
+--------------------------------------------------+------------------+[/tt]
Into something like this:
[tt]+------------------------------------------+
|18-hole Private |
+------------------------------------------+
|Dallas National, Dallas |
|Colonial Country Club, Fort Worth |
|Brook Hollow Golf Club, Dallas |
+------------------------------------------+
+------------------------------------------+
|18-hole Public |
+------------------------------------------+
|Crown Colony Country Club, Lufkin |
|Tour 18, Flower Mound |
|Squaw Valley, Comanche Lakes, Glen Rose |
+------------------------------------------+
+------------------------------------------+
|9-hole Courses |
+------------------------------------------+
|Starr Hollow, Tolar |
|Magnolia Ridge CC, Liberty |
|Stewart Peninsula, The Colony |
+------------------------------------------+[/tt]
Without having to use a procedural language.
Help?
Tia.