search engine help

[Anon]

Hello,
I've been trying to create a search engine. But there are so many articles and posts that I have read, that I'm confused now. I am trying to create a simple search engine. It will search for a keyword in my products table, product_name column. And return all products with that key word listed in its name. The articles I've been reading talk about setting up a flat text keyword file, and tons of code that I do not understand. This seems to be a bit advanced for my needs. Some posts have helped, but only mentioned certain parts of a search engine, and not the entire script. My questions: Is there any tutorials that explain how to create a simple search engine? I've already looked at all the articles under Devshed.com and Hotscripts.com. None seemed to help. Any help would be great. But I understand that most people will not write the code for me, and that is ok. I just need some direction. Thanks

Here is what I know I'll need.
SELECT * FROM tbl WHERE product_name LIKE '%" . $searchedWord . "%'

Jeremy

[pnoeric]

Jeremy - you're on the right track... sounds like you should ignore all talk of flat text fiels if you have a db already set up with what you want. The basic logic is:

1. Ask the user what they're searching for

2. Execute that SQL: "select * from tbl where product_Name like '%".$query."%';" (be sure to backslash-escape $query first or else you have a security hole!)

3. Display the results from the query, or "nothing found" if there is no result set.

Hope this helps.

best
Eric