Search function for ecommerce site

[lampip]

I am building an ecommerce site with php and mysql and want to include a search function. I have looked at many packages but they all result in google type page results. I want to index the products in the database and display search results as matching categories and individual products (as if they were navigating the site). It will be much more user friendly and logical for an ecommerce site. Does anyone know of software that does this type of think, or i could customize to do it? If not any other advice?

thank you,
peter

[DrDoc]

I'd recommend MySQL's fulltext search, MATCH ... AGAINST (). I have used that several times with great success. You do, however, want to customize it a little to suit your needs. Out of the box it is "good", but not "great".

[lampip]

Excellent, never heard of it. just looked it up and it might be exactly what i want.

has anyone else successfully used this? Any other thoughts.

thanks again for the reply.
peter