将表拆分为组 - PHP和MYSQL

Question

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.

Answer 1

first determine the highest RaceNo.

SELECT RaceNo AS RaceNoMAX FROM racecard WHERE RaceNo=max(RaceNo)

then make a for or a while loop with a function to draw the table

While ($i<RaceNoMAX ){
   $sql = "SELECT HorseNo, Horse Name, Win_bet, Show_bet, Place_bet 
   FROM racecard 
   WHERE RaceNo=$i ORDER BY HorseNo ASC";

$result = ...;

$php_function_to_draw_the_table = ...;

$++;

}