Simple Search Engine

wsh

I want to build a search engine. I have no idea how to make one that will search a huge database (100MB +) and display information in the most relevant order (like the search engines do like Lycos, Yahoo, PHP.net [by closest match]) I want it to search entries containing ANY of the words in the search query (so it would display Soccer Championship if someone searched for Championship Soccer). I only have MySQL and PHP on a cluster hosting account.

This is the SQL Table structure dump:

CREATE TABLE dbsearch (
  Title varchar(255) default NULL, //SEARCH THIS
  URL varchar(255) default NULL,
  Description varchar(255) default NULL, //AND THIS
  Category varchar(255) default NULL, //AND THIS
  E_Mail varchar(255) default NULL,
  Status varchar(255) default NULL //DISPLAY ONLY IF THIS IS SET TO 1
)

I dont want to use LIKE because I have more than 3 million entries and holy crap does it ever take a long time. PLEASE HELP ME WITH SAMPLE CODE OF HOW TO DO THIS... THANK YOU SOOO MUCH

wsh

My host has MySQL V 4.0.1A

Just wondering though... Can I query like:

mysql_query("SELECT * FROM dbsearch WHERE MATCH (Title, Description, Category) AGAINST ('$query' IN BOOLEAN MODE)");

How can I use the "" operator??? I want to be ably to search for any version of any of the words. For example using +query +word*. How can I parse the initial query (from a form method GET) and change it into words with the correct boolean operators as stated??? Plz provide a funciton or code to make it possible to break down the query and search the db in this fashion... or in the alpha can i not use this??

tomkleijkers

I don't want to be demotivating, but I don't think this will work. You'll have to do multiple searches at first. Second: If you only search the discriptions, you won't get good results. Google and others search complete sites! Thirth: If you don't have an own server, you cannot create to big searches. Your server will block them.

wsh

Ok... but my search engine works... not for something like NHL or AND or anything less than four letters (that would be an insane search retreiving many irrelevant things) ... but sometimes the server does block the searches but... what ya gonna do. I cant afford a server. But when I run it on my comp it works fine.