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

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.

Localhost, but it's practical solution.........

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

rply