Re: Query Error

[Thomas CORBIERE]

Hello,

According to the manual :

"Note that INNER JOIN syntax allows a join_condition only from MySQL 3.23.17 on. The same is true for JOIN and CROSS JOIN only as of MySQL 4.0.11."

So, I think this is because the version of MySQL you are using on the production version is too old for this syntax. You should write the join condition in the WHERE
clause instead.

SELECT sidekicknews_news.ID, sidekicknews_news.name, sidekicknews_news.mail, sidekicknews_news.title, sidekicknews_news.news, sidekicknews_news.timestamp, sidekicknews_news.kategorieID, sidekicknews_news.checked, sidekicknews_kategorie.id, sidekicknews_kategorie.name AS 'kategorie'
FROM sidekicknews_news, sidekicknews_kategorie
WHERE sidekicknews_news.kategorieID = sidekicknews_kategorie.id
AND sidekicknews_kategorie.name = 'Bongs'
ORDER BY timestamp DESC

Regards,

Thomas CORBIERE