Full text search trouble

blckspder

Hello,

Im trying to set up a site search for my website. Basically I have a bunch of keywords and their respective pages... Some keywords go to multiple pages... The keywords and pages are set up in different tables.. Im having trouble figuring out how to use the full text search to search multiple tables and compare the id number for the keyword to the pages. The only tutorial ive found is at http://www.onlamp.com/pub/a/php/2002/10/24/simplesearchengine.html?page=3

but its not for full text... the others on full text search just confuse me.. so basically im lost 😕 if someone could please help and put things in simple terms id really appreciate it thanks!

Antoni

Roger_Ramjet

First piont is that you cannot have a full text index across multiple tables. So, if searching is a priority then a single table is a better option.

Now I'm going to take a guess that you have a table for each page because that is the way you see it, not because that is the way the data should be stored. Have a read of these articles and then revise your table layout

database normalisation and design techniques
MySQL: an introduction to database normalisation

Once you have your data organised properly then searching it will be a lot easier. You might even find that you can understand full text search then, but if not then come on back and I'll help you.

blckspder

excellent thank you!