The Little Guy Posted December 25, 2009 Share Posted December 25, 2009 What would be the best way to find 5 related articles for the current article? I have a page that has a question and an answer, I would like to get 5 other pages that are related to the current page. What would be a good way to write something like this? The table has these columns: - id - category - question (fulltext search) - answer (short answer) - details (more information explaining the answer) - timestamp Quote Link to comment https://forums.phpfreaks.com/topic/186319-related-rows/ Share on other sites More sharing options...
trq Posted December 26, 2009 Share Posted December 26, 2009 How exactly are you defining the relationships? Quote Link to comment https://forums.phpfreaks.com/topic/186319-related-rows/#findComment-984100 Share on other sites More sharing options...
The Little Guy Posted December 26, 2009 Author Share Posted December 26, 2009 I'm not... I have a question in the database that is: "What does DNA stand for?" So basically I would like to then search the database for more information on DNA, and return the 5 top results. Quote Link to comment https://forums.phpfreaks.com/topic/186319-related-rows/#findComment-984135 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.