Hi all,

I need a search system that will do more than just basic keyword searching (boolean etc) BUT doesnt http spider a site, instead it will search a mysql database with fields i specify.

It can even index the site and create its own flat file database.
The key is that it needs to work with mysql and not spider a site.

Does anyone know of a system?

I have some code that will index the site (either once or through a cron job) and save all the data into an SQL database and then preform searches from the SQL database, is that what your looking for?

Originally Posted by riscphree

I have some code that will index the site (either once or through a cron job) and save all the data into an SQL database and then preform searches from the SQL database, is that what your looking for?

Not exactly. The problem is that i have a database that holds information that can only be accessed via a search engine of some sort. So i need to be able to specify which tables and fields the search system can search through using more than basic keyword terms. (boolean).

It also, (this is not essential, but more of a "nice to have") needs to be able to weight fields, so i can say that the "keywords" field is more important than the "body" field and therefore list them in order of weight. (did that make sense?)

Yeah, it made sense, but I have never seen a script that will do it. You might have to code one yourself.

I think you have to code yourself.

I got some interesting links while searching for you.
http://www.lib.berkeley.edu/Teaching...isibleWeb.html

have a look at PhpDig it has a crawler but you don't have to use it

I wish that I could be of help