Unknown Column in on clause after Upgrade to V5

<?php
// Construct db query to get fixtures from database.
$selectClause = "SELECT
                  M.MatchID AS id,
	         M.MatchAdditionalType AS additype,
	         O.OpponentName AS opponent,
	         O.OpponentID AS oppid,
	         M.MatchGoals AS goals,
	         M.MatchGoalsOpponent AS goals_opponent,
	         M.MatchPenaltyGoals AS penalty_goals,
	         M.MatchPenaltyGoalsOpponent AS penalty_goals_opponent,
	         M.MatchOvertime AS overtime,
	         M.MatchPenaltyShootout AS penalty_shootout,
	         DATE_FORMAT(M.MatchDateTime, '%M %Y') AS month,
	         DATE_FORMAT(M.MatchDateTime, '%a %e') AS date,
	         DATE_FORMAT(M.MatchDateTime, '%H:%i') AS time,
	         M.MatchPlaceID AS place,
                  M.MatchAttendance AS att,
	         M.MatchPublish AS publish,
	         MT.MatchTypeName AS typename,
	         P.PreviewText AS prewtext
	         FROM tplss_matches M, tplss_matchtypes MT, tplss_opponents O
	         LEFT OUTER JOIN tplss_previews P ON M.MatchID = P.PreviewMatchID ";
 
if (($defaultseasonid != 00) && ($defaultmatchtypeid != 0)) {
  $whereClause = "WHERE M.MatchTypeID = '$defaultmatchtypeid'
                  AND M.MatchSeasonID = '$defaultseasonid'
                  AND M.MatchTypeID = MT.MatchTypeID
	          AND M.MatchOpponent = O.OpponentID ";
} elseif (($defaultseasonid == 0) && ($defaultmatchtypeid != 0)) {
  $whereClause = "WHERE M.MatchTypeID = '$defaultmatchtypeid'
	          AND M.MatchTypeID = MT.MatchTypeID
	          AND M.MatchOpponent = O.OpponentID ";
} elseif (($defaultseasonid != 0) && ($defaultmatchtypeid == 0)) {
  $whereClause = "WHERE M.MatchSeasonID = '$defaultseasonid'
	          AND M.MatchTypeID = MT.MatchTypeID
	          AND M.MatchOpponent = O.OpponentID ";
} elseif (($defaultseasonid == 0) && ($defaultmatchtypeid == 0)) {
  $whereClause = "WHERE M.MatchTypeID = MT.MatchTypeID
	          AND M.MatchOpponent = O.OpponentID ";
}
 
$orderByClause = "ORDER BY M.MatchDateTime";
 
// Execute query.
$sql = $selectClause . $whereClause . $orderByClause;
$get_matches = mysql_query($sql, $connection) or die(mysql_error());
 
// Loop round fixtures (which come back from database in date order).
while($data = mysql_fetch_array($get_matches))
{
  // Print a month header row each time we hit a new month.
  if ($data['month'] <> $lastMonth) {
    echo "<tr>\n";
    echo '<td align="left" valign="middle" bgcolor="#009933" colspan="9">';
    echo '<font color="#FFffff"><b>' . $data['month'] . "</b></font>";
    echo "</td>\n";
    echo "</tr>\n\n";
    $lastMonth = $data['month'];
  }
 
  // Assign home/away based vars.
  if ($data['place'] == 1) {
    $placeBg = $bg4;
    $venue = "H";
  } else {
    $placeBg = $bg3;
    $venue = "A";
  }
 
  // Print date, ko time and venue.
  echo"<tr>\n";
  echo '<td align="left" valign="middle" bgcolor="' . $placeBg . '">';
  echo $data['date'];
  echo "</td>\n";
 
  echo '<td align="center" valign="middle" bgcolor="' . $placeBg . '">';
  echo $data['time'];
  echo "</td>\n";
 
  echo '<td align="center" valign="middle" bgcolor="' . $placeBg . '">';
  echo $venue;
  echo "</td>\n";
 
  // Print opponent team name (as a link if possible).
  echo '<td align="left" valign="middle" bgcolor="' . $placeBg . '">';
  if ($data['oppid'] == 1) {
    echo '$data[opponent]';
  } else {
    echo '<a href="opponent.php?opp=' . $data['oppid'] . '">' . $data['opponent'] . "</a>";
  }
  echo "</td>\n";
 
  // Print competition type.
  echo '<td align="left" valign="middle" bgcolor="' . $placeBg . '">';
  echo $data['typename'];
  if ($data['additype'] != '') {
    echo " / " . $data['additype'];
  }
  echo "</td>\n";
 
  // Print result, attendance and match report.
  if ($data['goals'] == NULL || $data['goals_opponent'] == NULL) {
    // No goals recorded - match can't have been played yet - print empty fields.
    echo '<td bgcolor="' . $placeBg . '">&nbsp;</td>' . "\n";
    echo '<td bgcolor="' . $placeBg . '">&nbsp;</td>' . "\n";
    echo '<td bgcolor="' . $placeBg . '">&nbsp;</td>' . "\n";
    echo '<td align="center" valign="middle" bgcolor="' . $placeBg . '">';
    if ($data['prewtext'] == '') {
      echo "&nbsp;";
    } else {
      echo '<a href="preview.php?id=' . $data['id'] . '">' . $txt_preview . "</a>";
    }
    echo "</td>\n";
  } else {
    // Goals recorded - figure out result and score - print required fields.
    if ($data['penalty_goals'] == NULL || $data['penalty_goals_opponent'] == NULL) {
      if ($data['goals'] > $data['goals_opponent'])
	$result = "<b>W</b>";
      elseif ($data['goals'] < $data['goals_opponent'])
	$result = "L";
      else
	$result = "D";
      $score = $data['goals'] . " - " . $data['goals_opponent'];
    } else {
      if ($data['penalty_goals'] > $data['penalty_goals_opponent'])
	$result = "<b>W</b>";
      else
	$result = "L";
      $score = $data['goals'] . " - " . $data['goals_opponent'] . " (" . $data['penalty_goals'] . " - " . $data['penalty_goals_opponent'] . ")";
    }
    echo '<td align="center" valign="middle" bgcolor="' . $placeBg . '">' . $result . "</td>\n";
    echo '<td align="center" valign="middle" bgcolor="' . $placeBg . '">' . $score . "</td>\n";
    echo '<td align="center" valign="middle" bgcolor="' . $placeBg . '">' . $data['att'] . "</td>\n";
    if($data['publish'] == 1)
    {
    echo '<td align="center" valign="middle" bgcolor="' . $placeBg . '"><a href="matchdetails.php?id=' . $data['id'] . '">Report</td></a></td>' . "\n";
    }
    else
    {
    echo '<td align="center" valign="middle" bgcolor="' . $placeBg . '"> </td></a></td>' . "\n";
    }
  }
 
  echo "</tr>\n\n";
}
 
// Free resultset.
mysql_free_result($get_matches);
 
?>

Select allOpen in new window