Help with mysql 5.0.22

[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 


[Marco van Herwaarden]

FROM soccer_national_matches M, soccer_national_matchtypes MT, soccer_national_opponents O

How do you join the above 2 tables????

LEFT OUTER JOIN soccer_national_previews P ON M.MatchID = P.PreviewMatchID

Try instead:

LEFT OUTER JOIN soccer_national_previews P ON (M.MatchID = P.PreviewMatchID)

[Lionel]

I fixed it by doing
FROM (soccer_national_matches M, soccer_national_matchtypes MT, soccer_national_opponents O)

[Marco van Herwaarden]

Well congratulations, you have just created a cartesian product.

http://en.wikipedia.org/wiki/Cartesian_product

(in short: each row in table A will be matched with each row in table B, giving you "rows in A" times "rows in B" result rows)

[Lionel]

LOL, it displays