adder - 9:35 am on Sep 4, 2012 (gmt 0)
@jon22 - if you want it to be clever, you'd have to introduce some sort of a scoring system based on relevancy. e.g. an item that has the keyword in the title, description and tags row gets a higher score (and is displayed above the less relevant results).
Regarding pagination, see if you can adapt and modify this script phpeasystep.com/phptu/29.html It's pretty good.
Make sure you index all these fields properly
@IncrediBILL, I must admit I haven't indexed my database. Can you please point me to some manuals or info on indexing?