You'll want to order by RACE NAME
Then
<cfoutput query = "race Info" group = "RACE NAME">
Race info
<cfoutput>
Stuff
</cfoutput>
</cfoutput>
On Tue, 27 Jul 2004 14:55:52 -0400, Jeff Fongemie
<[EMAIL PROTECTED]> wrote:
> Hey everyone.
>
> I'm stumped.
>
> I need to be able to display a list of bicycle races, and under the race list the riders names and positions. I'd like to have two tables so the admin adding the data only needs to enter the race name and date once, then adds the riders in a seperate table linked by a raceid.
>
> Right now I've got two tables, one for the races, one for riders linked by common field raceid.
>
> The above seems fine, but I'm having trouble querring and displaying results. What I need should look like this:
>
> RACE NAME, DATE, COUNTRY
> ridername, place, team
> ridername, place team
> ridername, place team
>
> RACE NAME, DATE, COUNTRY
> ridername, place, team
> ridername, place, team
>
> and so on.
>
> Display the race info once, and then the riders under that.
>
> Do I join at the query? Group at the query? Group at the output?
> This shows me everything:
> SELECT *
> FROM riders, races
> WHERE riders.raceid=races.raceid
>
> I wish I could do this:
> SELECT *
> FROM riders, races
> WHERE riders.raceid=races.raceid
> Group By Raceid
>
> Any suggestions would be most appraciated.
>
> Thanks,
>
> JF
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
