code to show related posts in website

[rpv_sen]

Hi

I need an help on showing related post in an website. i want to display my related posts with help of keywords column.
Below is my database structure

id              int(12)
title           varchar(250)
content         varchar(250)
image_path      varchar(250)
type            varchar(250)
keywords        varchar(250)

can any one please help me.
Thanks

[pritaeas]

Like this perhaps?

http://www.daniweb.com/web-development/php/code/460663/article-tagging-example

[dom246]

Nice find Pritaeas. I would definitely recommend looking into a freetexttable or full text search depending on the database you are using. These are more efficient and you will get better results.

http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html