Table sub row title technique

[notonurnelly]

Hi All,

bit of a newbie question here, what I am trying to do is to loop through reocrds within my recordset and write them to a table. I can do that quite easily. what I want to do is to take a repeated value in my one of the columns in my table and make that into a sub heading. Underneath that I want to display all the reocrds for that value. Then display the next repeated value with all of the values for that

Say for example my table display is

Month            Date            RaceName          Venue
January          11/1/06        Ben Nevis          Scotland
January          21/1/06        3 Shires            England
February        1/2/06          London              England
February        5/2/06          Snowdon          Wales
February        6/2/06          Paris                France
March            6/3/06          hamburg            Germany

What i would like to do is, have each month as a sub heading as below

                    Date            RaceName          Venue
January
                  11/1/06        Ben Nevis          Scotland
                  21/1/06        3 Shires            England
February     
                  1/2/06          London              England
                  5/2/06          Snowdon          Wales
                  6/2/06          Paris                France
March           
                  6/3/06          hamburg            Germany

This technique can be seen on the following site

http://www.scottishhillracing.co.uk/Fixtures.aspx

I have tried searching the tutorial section but cannot find anything.

Can anyone descibe this technique to me or point me to a tutorial

Many thanks
jamie


             

[Barand]

I have just answered a very similar case here

http://www.phpfreaks.com/forums/index.php/topic,108283.msg439621.html#msg439621