I'm working as a programmer for a major travelling agency. I'm quite experienced, but now I ran into a problem that requires kind of an AI to be built up. I know these kinds of scripts exist everywhere, but I can't seem to find anything useful.
Basically we're building a FAQ script. We're getting loaded up with e-mails of the same types of questions every day, so we want to build a contact form which works just as it does while I'm writing this: In the right side it presents a number of already answered questions which are somehow similar to what I'm writing right now. The same happens while I write the subject.
Well, to get down to business. I'm making a contact form, but as the client is writing the subject and/or message, I want a number of pre-defined Q&A's to be presented for them as they write. I believe that I'm not able to use soundex
as the FAQ will be in danish and thereby not sounding phonetically like english.
So.. How would I:
- Build up the database? Should I use fulltext or tags, and extract the known tags from the message?
- Build up the PHP script? Are there any functions that you think I should know of?
Basically I'm researching, so I would be very grateful for merely simple SQL queries as well as full scripts designed for the purpose! Anything is useful.