0

Hi,

I wrote a qyery:

SELECT introtext FROM jos_content JOIN jos_sections 
ON jos_content.sectionid = jos_sections.id
WHERE jos_sections.title = 'Redaktores zodis'
ORDER BY publish_up, DESC;

If I don't use ORDER BY then it works. But with it it throws error:

Query : select introtext from jos_content join jos_sections on jos_content.sectionid = jos_sections.id where jos_sections.title = 'Re...

Error Code : 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'desc LIMIT 0, 1000' at line 4

What is wrong there?

2
Contributors
2
Replies
4
Views
6 Years
Discussion Span
Last Post by McLaren
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.