Find solution
What does database developers actually do?

PHP Developers: Which is the best solution to display the related posts from a database?

  • Hey , I would like to know which is the best way to get related posts from a database (php & mysql). I know about MATCH / AGAINST method and I saw a few plugins on wordpress which works with this method. I'm not sure if this method is ok to be used or fi exists a better one. thank you !

  • Answer:

    save keywords in in the database while uploading... related topics will be the posts matching any of these keywords

Deepak R Pillai at Quora Visit the source

Was this solution helpful to you?

Other answers

use Keywords, Google itself use the Keywords to get results. that mean when you write a post add keywords and save in SQL database then in PHP get all keywords from the database in an array and then you need to match with the other arrays.

Oussama Bezzad

If you are using Wordpress, you could use tags or taxonomies depending on your needs. There are also plugins that let you manually specific related posts/items to each post. It really depends on what you trying to accomplish.

Eric Lozaga

Adding lots of keywords. Add keywords with the post. Now, an SQL query is executed to find the particular keyword that matches with your post. Search Engines also use this technique.

Soumyargha 'Sam' Sinha

Try using  Mysql Regular expression feature. Query to find all the names starting with 'st' SELECT name FROM person_tbl WHERE name REGEXP '^st' Query to find all the names ending with 'ok' SELECT name FROM person_tbl WHERE name REGEXP 'ok$'; http://www.tutorialspoint.com/mysql/mysql-regexps.htm

Pandu Ranga Rao

Related Q & A:

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.