Need A Searchable Database For Tech Prob

Anon

I work for a web hosting company as a tech. Franky, tired of getting the same questions over and over and having to type the same responces, and Im sure other techs are as well. Anyways, I know a little about PHP and not much on mySQL, but Im eager to learn. What I want to do is make a web-based searchable database for problems people may be having, and have it return some solutions in text files on on a html file or however it works and it display what we need to tell the customer to do to correct the problem. How would I go about accomplishing this and can someone point me in the right direction? Thanks.

[deleted]

Read this article on makeing a search engine -> http://www.phpbuilder.com/columns/clay19990421.php3

You're also going to have to make a table with at least three fields (id, question, answer)

create table q_and_a (id int auto_increment primary key, question varchar(100), answer text);

after you read that article, you'll have a general idea of how it works.

good luck
mark

Anon

You\'ll need to write a multi-querying interface preferably with dropdowns to limit the users\' choices, passing the query from page to page in hidden inputs, and then use wildcards to search (% in php).
you can write your final sql query like this:

select * from tablename where $searchname like \'%$string%\'