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)



Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------

[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. :D

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 (http://www.haitiwebs.com/haitianforums/football/national/matches.php)