[PHP-WIN] Re: Subject: help! for my project...

[Neil Smith]

Hi Jeffry - first thing I would do in a real world situation is to take 
advantage of the power of MySQL features. Most imortantly, to search a 
site, I would ask you to look up in the MySQL manual :

FULLTEXT INDEX

feature in MySQL. This indexes and sorts your specified fields as you 
insert them, so you don't have to. You then have an index of words in the 
DB. Fulltext also ranks words with a threshold, so that if for example a 
lot of text contains the word 'the', it is given a low specificity and not 
returned in searches.

Hope that helps
Regards,
Neil Smith.
At 13:36 24/02/2003 +0000, you wrote:
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Message-ID: <[EMAIL PROTECTED]>
Date: Mon, 24 Feb 2003 16:59:12 +0800
From: "Jeffrey S. Payao" <[EMAIL PROTECTED]>
MIME-Version: 1.0
To:  [EMAIL PROTECTED]
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
Subject: help! for my project...
hi guys! can anyone please help me in my project. please. im currently 
creating my thesis, a site with a search engine. i googled and found a lot 
for my projects. now my problem is i cant display my article links. :( im 
using php+apache+mysql on my w2k. here are the following code i took from 
http://www.devarticles.com/



create table searchWords
 (
  wordId int auto_increment,
  word varchar(50),
  articleIds varchar(255),
  primary key(wordId),
  unique id(wordId)
);
insert into articles values(0, 'MySQL is a great database', 'If you\'re 
after a top quality database, then you should consider MySQL. MySQL is 
packed with features, and can be installed on both Linux and Windows 
servers.');

insert into searchWords values(0, 'MySQL', '1');

insert into searchWords values(0, 'install', '1');


--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php