I have a rather complex MySQL query to generate.
We have 2 Tables:
answers which lists all the replies by members
articles which lists all the articles to which these answers are posted to
What we want to do is to generate a query which produces a list of all articles to which a member has posted an answer to, based on latest answer posted. We have this SELECT but it is not producing the results based on the latest answer posted, but it produces results based on latest article posted!
Here it is:
SELECT qq.id, qq.date_added, head_line FROM answers AS qa INNER JOIN articles AS qq ON (qa.qa_id = qq.id) WHERE qa.user_id = 55555555 GROUP BY qq.id ORDER BY qa.id DESC;
So how do you correct this to show the list of articles to which this member has posted an answer to based on article to which he has posted the last answer to?
Thanks to MySQL Gods for answering this