Search Engine Logic?

[bhappy]

Hi All,

I am doing search engine in my home page. It will search all products details for a specified pattren/search keyword in all categories. It should display the first product as the most character match of key words which the user has entered for the Products. Any idea plz......................

My logic is prod_name like '%mobile%'

Thanks.

[Plater]

Well I'm not sure what a search engine has to do with it, your %string% seems like a workable enough solution. Just find a way to format the results into something that looks nice?

[r035198x]

Suppose you are searching for two words " scripts byte" from a column in a table which has two rows with

row1 "the scripts byte"
row2 "the byte"

If you take the search string entered and break it up into an array and then do

 for(int i=0;i < array.Length;i++) {
                    select rowID from tableName where
                     upper(colName) like upper('%array[i]%')
                     add rowID to an ArrayList called IDs here
}

After all this the IDs ArrayList can easily tell you which row had the most hits.


Note:

• This technique is a brute force one and is probably the slowest.

• Getting results from a database inside a for loop requires motherly care.