View Single Post
  #1  
Old 08-09-2006, 11:49 AM
duoie duoie is offline
Junior Member
 
Join Date: Aug 2006
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
duoie is on a distinguished road
Exclamation making search engine

Hello buddies

I want to make a simple search engine that will look through my web pages. The content of each page is stored in a field of a table. I do the following

select page_title from sth where content like '%user's query%'

this brings me the names of the proper pages. I want to know and be able to show the correct matches for every page so i can sort the results. How can i change my query for doing that ? I think that i should use a subquery but i have no idea what to put.

Thanks in advance for your inputs -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --
Reply With Quote
  Webmaster Forums - View Single Post - making search engine
View Single Post
  #1  
Old 08-09-2006, 11:49 AM
duoie duoie is offline
Junior Member
 
Join Date: Aug 2006
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
duoie is on a distinguished road
Exclamation making search engine

Hello buddies

I want to make a simple search engine that will look through my web pages. The content of each page is stored in a field of a table. I do the following

select page_title from sth where content like '%user's query%'

this brings me the names of the proper pages. I want to know and be able to show the correct matches for every page so i can sort the results. How can i change my query for doing that ? I think that i should use a subquery but i have no idea what to put.

Thanks in advance for your inputs -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --
Reply With Quote