|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Codewalkers Forums Sponsor:
|
|
|
|
#1
March 15th, 2003, 04:02 PM
|
|||
|
|||
|
Grouping data...help...
Well, I have database like this...
[League],[Team A],[Team B]...[n] A xxx yyy A xxx yyy A xxx yyy B xxx yyy B xxx yyy B xxx yyy C xxx yyy C xxx yyy C xxx yyy ...and want to display results like this A --------- xxx yyy xxx yyy xxx yyy B --------- xxx yyy xxx yyy xxx yyy C --------- xxx yyy xxx yyy xxx yyy ...anyone got the idea...can help me? Thanks!
|
|
#2
March 16th, 2003, 06:15 AM
|
|||
|
|||
|
RE: Grouping data...help...
look at ORDER BY sql statement. your query should look smth like:
Code:
SELECT league, team_a, team_b FROM table ORDER BY league and whenever the league changes from row to row, you print row header..
|
|
| Viewing: Codewalkers Forums > Other Technologies > Database Help > Grouping data...help... |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
