PHP Search Engine

[joeiscoolone]

I am trying to build a PHP search engine that just searches a table and ranks by occurence of words. I dont want it to crawel and index the site and then search it, I just want it to search the entire table every time a search is preformed. I looked at some sites that teach you how to build a PHP search engine but they did not explian it clearly anough. I dont want to make a super complex search engine just one that searches a table and ranks by word occurrence. Could someone show me a code example of a small search engine like that and explian in detail how to set it up.

[kakki]

no idea how that will work in mysql, but in php:

while( $line=mysql_fetch_array( ... ) )
{
preg_match_all( '#searchWord#msiU', $line[ 'content' ], $foundArray );
// occurence of searchWord is sizeof( $foundArray )
}

maybe you can write your own mysql-function for that....