The table name is racecard. Today, there are 9 races.
The table structure looks like this:
RaceNo HorseNo HorseName
1 1 FAJR
1 2 CUT DIAMOND
1 3 VOICE OF FAITH
1 4 CEASARINA
1 5 JAIPUR GEM
1 6 KATNISS
1 7 PLAN B
1 8 CLASSY DANCER
1 9 RAJASTHAN GLORY
1 10 HIGHWAY EXPRESS
1 11 TAJ E SHAHI
2 1 VICTORIOUS MARCH
2 2 DEMONSTRATOR
2 3 MYLA ROSE
2 4 RIO
2 5 MONZA
3 1 TITLEIST
3 2 SUNTAN BEAUTY
3 3 VICTORIAN
3 4 LAURUS PRIDE
...
I am trying to create a PHP page in that the entire table is grouped by race no.
The page should have the sub-headings like Race No -1, Race No - 2:
Race No: 1
HorseNo Horse Name Win bet Show bet Place bet
1 FAJR textbox textbox textbox
2 CUT DIAMOND textbox textbox textbox
3 VOICE OF FAITH textbox textbox textbox
4 CEASARINA textbox textbox textbox
5 JAIPUR GEM textbox textbox textbox
6 KATNISS textbox textbox textbox
7 PLAN B textbox textbox textbox
8 CLASSY DANCER textbox textbox textbox
9 RAJASTHAN GLORY textbox textbox textbox
10 HIGHWAY EXPRESS textbox textbox textbox
11 TAJ E SHAHI textbox textbox textbox
Race No: 2
HorseNo Horse Name Win bet Show bet Place bet
1 VICTORIOUS MARCH textbox textbox textbox
2 DEMONSTRATOR textbox textbox textbox
3 MYLA ROSE textbox textbox textbox
4 RIO textbox textbox textbox
5 MONZA textbox textbox textbox
and so on. Also, there should be columns with text boxes for entering the bet amounts. When the user submits the form, the betting details should be stored in the betting table with respective race no, horse no and bet amount. I need to use array. Please help me in coding.