Race Calendar

[Simracer2018]

Hello. Maybe it is also possible to add the column season in the race calendar right in front of the race which automatically shows the season that will be driven on the track. Greeting armin

[avs-code]

I think so, yes, let me have a look tomorrow.

[Simracer2018]

No Problem. Thanks !!!!!!!

[avs-code]

Show_circuits.php, line 4. Check code to match with this:

$circuits = "SELECT race.track, race.name, race.division, race.date, race.imagelink, race.maxplayers, race.season, division.name AS division_name, season.name AS season_name FROM race LEFT JOIN division on division.id=race.division LEFT JOIN season on season.id=race.season WHERE race.date>=CURDATE() ORDER BY race.division ASC, race.date ASC";

Line 22:

<td>Season</td>

Line33:

<td><?= $sitem['season_name'] ?></td>

That show this column order:

<td>Name</td>
<td>Track</td>
<td>Division</td>
<td>Season</td>
<td>Date</td>
<td>Image</td>

<td><?= $sitem['name'] ?></td>
<td><?= $sitem['track'] ?></td>
<td><?= $sitem['division_name'] ?></td>
<td><?= $sitem['season_name'] ?></td>
<td><?= $sitem['date'] ?></td>

Change the order of lines to change the order of columns

[Simracer2018]

Thanks again quick work, Top !!! Is working