2014-03-08 10:34
浏览 37


I'm fairly new to PHP, but have been able to use include files previously.

I'm trying to include a dynamic league standings table to a page.

The code works fine on the page on its own, but when I try to add it into an include file, it just displays the script. I assume that it's an issue with what you can use in an include, but I'm struggling to work out what the rules of what you can or can't do in an include file are??

Both files are sat in the same directory, and i'm using the syntax.

The code I'm trying to include is:

      $result = mysql_query("
        select team, 
        count(*) played, 
        count(case when HomeScore > AwayScore then 1 end) wins, 
        count(case when AwayScore > HomeScore then 1 end) lost, 
        count(case when HomeScore = AwayScore then 1 end) draws, 
        sum(HomeScore) goalsfor, 
        sum(AwayScore) goalsagainst,
        sum(HomeScore) - sum(AwayScore) goal_diff, 
        sum(case when HomeScore > AwayScore then 3 else 0 end + case 
        when HomeScore = AwayScore then 1 else 0 end) score 
        from (select 
            HomeTeam team, 
        from Game 
            union all 
        select  AwayTeam, 
        from Game) a 
        group by team 
        order by score desc, 
        goal_diff desc;");

  echo "<table border='1'>
    <th>Goals For</th>
    <th>Goals Against</th>

  while($row = mysql_fetch_assoc($result))
      echo "<tr>";
      echo "<td>" . $row['team'] . "</td>";
      echo "<td>" . $row['wins'] . "</td>";
      echo "<td>" . $row['lost'] . "</td>";
      echo "<td>" . $row['draws'] . "</td>";
      echo "<td>" . $row['goalsfor'] . "</td>";
      echo "<td>" . $row['goalsagainst'] . "</td>";
      echo "<td>" . $row['score'] . "</td>";
      echo "</tr>";
  echo "</table>";

Apologies for the formatting, still getting used to spacing!

Thanks guys

  • 写回答
  • 好问题 提建议
  • 关注问题
  • 收藏
  • 邀请回答

1条回答 默认 最新

  • douhuan1908 2014-03-08 10:38

    Enclose the all of PHP code in tags.

    解决 无用
    打赏 举报

相关推荐 更多相似问题