Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Posts
    17

    Question Unanswered: how to display records based on search critria(Exact match record should come first)

    Hello Everyone,

    i am developing one site, in which i have been stucked with following query.

    supoose there are 10 fields in table.
    now with advanced search, the records that match exactly 10 fields should come up first and records that match 9 fields should come up later.

    please help to get rid of it.

    thanks in advance

  2. #2
    Join Date
    Oct 2003
    Posts
    13
    Sounds a little tricky...

    My first instinct would be to write ten separate queries (match 10, match 9, match 8, etc) and then take the UNION of all of them, however that seems messy.

  3. #3
    Join Date
    Jan 2004
    Posts
    17
    Localhost, but it's practical solution.........

    there will b something....ne way....pls help.
    it's urgent for me...

    rply

Posting Permissions

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