[Lionel]

I just moved to a new server with php 5.16 and mysql 5.0.22

some codes which were working just fine before now are throwing some errors (Unknown column 'M.MatchID' in 'on clause') column exists!. Please can someone tell me what is wrong with that code (non vb)

PHP Code:

 $get_matches = mysql_query("
 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, '$how_to_print') AS time,
  M.MatchPlaceID AS place,
  M.MatchPublish AS publish,
  MT.MatchTypeName AS typename,
  P.PreviewText AS prewtext
 FROM soccer_national_matches M, soccer_national_matchtypes MT, soccer_national_opponents O
 LEFT OUTER JOIN soccer_national_previews P ON M.MatchID = P.PreviewMatchID