search keywords in all pages in my website

[lvenkatesh]

Hi,

I'm trying to build a simple search engine to my PHP site. I finished building my MySQL database, which includes 15 tables. Now I don't know how can I search words trough my database..

I want that when I search few words it will return me the name of tables which there exist in.

How can I do it?

Thanks in advance.

[bradgrafelman]

First question would be... do you need to re-invent the wheel? For example, is something like Google Site Search not an option?

Next question would be... Why do you have 15 tables in your database? If you're searching for data and don't know which table you need to look in, that's almost a sure sign that you've got a bad database design.