PHP search engine?

[blanketyblank]

I'm building a new MySQL database-driven website and I was wondering what the best option for creating an internal search engine is. The site is hosted by a third party and I have no telnet access, so installing server-side software is not an option.

I've seen PHP scripts that can do the job, but I want to be able to search the database data and non-database HTML files simultaneously.

For example, let's say I have a MySQL database of cars -- model, company, year, engine etc. But I also have stand-alone webpages dedicated to buying cars, selling cars, etc. Can these PHP scripts index both, or are they limited to one or the other?

I've seen Sphider (http://www.sphider.eu/) and Sphinx (http://www.sphinxsearch.com/), is there some kind of script solution here? Or am I going about building an internal search engine in the wrong way?

Thanks for any advice.

[icehose]

I recently installed Zend's open source Framework (http://framework.zend.com) for the sole purpose of getting my hands on their PHP implementation of the JS Lucene Project's search engine. It took a couple of hours to isolate and strip out just the Lucene module (which you may not need/want to do). I then discovered that it works ONLY on PHP5 and my main server was still using PHP4. So, I spent far too much time backporting the Lucene code to PHP4 -- I got it working but by that time I had talked my host into upgrading to PHP5. So, I'm now using my "stand-alone" Lucene module to perform full-text searching of 7K+ html files that I have archived. Using the module is simple -- it looks like just another (big, hierarchical) class that you require_once, instantiate and invoke. Building the search "index" took a bit of CPU time, but, once built, searching is blazing fast! Nice module.

Note: I use MySQL for ALL of my database searching and would not think of doing anything different here!