Add a table column

ahyman1

I want to add a column named "Position" to the left of the "team" column. In this column I want "1" "2" and "3" under the column. I have tried to put this outside the loop but it hasn't worked. How would I do this ? The code I am using is

[CODE] <table border ="1">



<tr>

<td>Team</td> <td>Goals For</td> <td>GD</td> <td>Points</td></tr>

<?php
while($column = mysql_fetch_array($league_table))
{

  echo" 



		<td> $column[team] </td>
		<td> $column[goals]</td>
		<td> $column[difference]</td>
		<td>$column[points]</tr></td>

        </tr>";
    }
	?>
    </table>[/CODE]

autocolismo

don't know if it's your problem but there's an </tr> that shouldn't be there:

<td>$column[points]</tr></td>

autocolismo

  <?php
   while($column = mysql_fetch_array($league_table))
   {

  echo" 


        <tr>
		<td> $column[team] </td>
		<td> $column[goals]</td>
		<td> $column[difference]</td>
		<td>$column[points]</td>

        </tr>";
    }
	?>

Damian_

Oh i think i know what you mean


  <?php
$i = 1;
   while($column = mysql_fetch_array($league_table))
   {

  echo" 


        <tr>
        <td> $i </td>
        <td> $column[team] </td>
        <td> $column[goals]</td>
        <td> $column[difference]</td>
        <td>$column[points]</td>

        </tr>";
$i++;
        }
        ?>

try that?

ahyman1

Damian_;11025459 wrote:

Oh i think i know what you mean


  <?php
$i = 1;
   while($column = mysql_fetch_array($league_table))
   {

  echo" 


        <tr>
        <td> $i </td>
        <td> $column[team] </td>
        <td> $column[goals]</td>
        <td> $column[difference]</td>
        <td>$column[points]</td>

        </tr>";
$i++;
        }
        ?>

try that?

That works exactly how I wanted it to . Thanks very much

ahyman1

Don't know if you would be able to help me anymore possibly? I'm now trying to work the amount of wins, draws and losses each team has and place this on the league table, also the goals conceded as for some reason only the goals for calculated. Below is the code that I have used to calculate the points, goals for and goal difference headings:

    $league_table = mysql_query("SELECT team,sum(goals) as goals,sum(points) as points, (difference) as difference FROM(
 SELECT fixtures.hometeam as team, sum(results.homegoals) as goals,sum(results.homepoints) as points,(results.homegoals - results.awaygoals) as difference
  FROM fixtures inner join results on results.fixtureteams = fixtures.fixtureid
  where fixtures.leaguename='$leaguename' 
  group by fixtures.hometeam
  union

  SELECT fixtures.awayteam as team, sum(results.awaygoals) as goals,sum(results.awaypoints) as points, (results.awaygoals-results.homegoals) as difference
  from fixtures inner join results on results.fixtureteams = fixtures.fixtureid
  where fixtures.leaguename= '$leaguename'   

  group by fixtures.awayteam
  ) as league group by team order by points desc, difference desc");


  ?>