Gossamer Forum
Home : Products : Gossamer Links : PHP Front End :

Search in php

Quote Reply
Search in php
While 90% of my page is in php, i dont want to have search.cgi anymore. For this i make my own search now. To repeat if i have understood the indexed search right (and maybe for somebody who wants to now) i found out:

Links_Word_List stores
ID (auto_inc)
Word (the word itself)
Count (how often this word is found)

and

Links_Score_List
Word_Id (=ID from Word_List)
Item_ID (=LinkID)
Score
Wordposition

The score could be, i will test it in a minute like following:

Title, value 2
Descr, value 1

So if the word "test" is in Title and Descr it has a score of 3, when only in Descr a score of 1, when only in Title a score of 2.

Seems easy and i am glad about this, while i could easily make my sql-queries in php now.

The reason for an existing position i dont know, maybe because of high-lighting and because it is faster to count the words position than to have another regex to find the whole word?
Subject Author Views Date
Thread Search in php Robert 3864 Dec 31, 2007, 2:59 AM
Post Re: [Robert] Search in php
Robert 3755 Jan 5, 2008, 2:42 PM