HTML table from MySQL data

HTML table from MySQL data

Closed - This job posting has been filled.

Job Description

I need an html table populated with data from a MySQL db table. The data will be dependent on the 'PLAYER' and 'TEAM'. The <th> 'TEAM' and the 'PLAYER' <td> will be changed frequently. The 'POS' <td> will be static(never changing). The 'ASTRAL' <td> will be taken from the 'total' column in the db table and is dependent on the player name. 'PLAYER' will be from 'player' column, and the 1st <th> in the html table will be from 'team' column in db table. The table requires some math functions for some of the <tr><th>, like the Line 1, line 2, Line 3, and Line 4 'ASTRAL' and for the 'TEAM ASTRAL' 'ASTRAL'.

Here is the html table:
<!--This is the 'TEAM'-->
<tr><th colspan="3">CANADIENS</th></tr>

<tr><th style="color: black">POS</th><th style="color: black">PLAYER</th><th style="color: black">ASTRAL</th></tr>

<tr><td>G</td><td style="text-align: left">Carey Price</td><td>2315</td></tr>

<tr><td>LW1</td><td style="text-align: left">Alex Galchenyuk</td><td>737</td></tr>
<tr><td>C1</td><td style="text-align: left" >Lars Eller</td><td>512</td></tr>
<tr><td>RW1</td><td style="text-align: left">Brendan Gallagher</td><td>-1043</td></tr>
<tr><td>D1</td><td style="text-align: left">Andrei Markov</td><td>1439</td></tr>
<tr><td>D1</td><td style="text-align: left">P.K. Subban</td><td>685</td></tr>
<tr><th colspan="2">Line 1 ASTRAL</th><th style="color: black">466</th></tr>

<tr><td>LW2</td><td style="text-align: left">Michael Bournival</td><td>-498</td></tr>
<tr><td>C2</td><td style="text-align: left">Tomas Plekenac</td><td>3463</td></tr>
<tr><td>RW2</td><td style="text-align: left">Brian Gionta</td><td>942</td></tr>
<tr><td>D2</td><td style="text-align: left">Josh Gorges</td><td>3316</td></tr>
<tr><td>D2</td><td style="text-align: left">Raphael Diaz</td><td>566</td></tr>
<tr><th colspan="2">Line 2 ASTRAL</th><th style="color: black">466</th></tr>

<tr><td>LW3</td><td style="text-align: left">Rene Bourque</td><td>316</td></tr>
<tr><td>C3</td><td style="text-align: left">David Desharnais</td><td>1143</td></tr>
<tr><td>RW3</td><td style="text-align: left">Louis LeBlanc</td><td>795</td></tr>
<tr><td>D3</td><td style="text-align: left">Douglas Murray</td><td>-198</td></tr>
<tr><td>D3</td><td style="text-align: left">Francis Bouillon</td><td>774</td></tr>
<tr><th colspan="2">Line 3 ASTRAL</th><th style="color: black">466</th></tr>

<tr><td>LW4</td><td style="text-align: left">Mike Blunden</td><td>3068</td></tr>
<tr><td>C4</td><td style="text-align: left">Ryan White</td><td>1458</td></tr>
<tr><td>RW4</td><td style="text-align: left">George Parros</td><td>2761</td></tr>
<tr><th colspan="2">Line 4 ASTRAL</th><th style="color: black">466</th></tr>

<tr><th colspan="2" style="color: #0000FF">TEAM ASTRAL</th><th style="color: #0000FF">1186.89</th></tr>

Other open jobs by this client