To develop a Search Page

Results 1 to 3 of 3

Thread: To develop a Search Page

  1. #1
    Anupama Guest

    Default To develop a Search Page

    I want a search page for my magzine.From the database i am fetching articles which have the search string given by the user.<BR>I want to diplay them in descending order of Rank.Rank is no of times the search string appears in a record.How to get this value of Rank???My database is just giving me the records in which the search string appears not the no of times it is appearing in each record

  2. #2
    Fred Guest

    Default RE: To develop a Search Page

    Possible Solution:<BR><BR>In your query make it return DISTINCT records, where you retreive the records for the search, add a extra field RANK, that will hold the number of times a particular record occurs. <BR><BR>You will need a sub-query which will use the Count method, which will scroll through your resultset and insert the number of times a particular record is repeated into the RANK fields and now use the ORDER method to sort in ascending or descending order.<BR><BR>The actual implementation is quite involved but not that difficult.

  3. #3
    Anupama Guest

    Default RE: Thanks

    the procedure has become too complicated but it works.Thanks a lot

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts