Search query for advance search of Matrimonial website

tinyprogram's Avatar, Join Date: Jan 2011
Go4Expert Member
Hi...

I am getting trouble in writing a query for multiple selection in a Matrimonial website..

e.g. If someone searches for a groom with religion as Hindu or Muslim, caste as Kayastha, Shudra, Vaishya or Kshtriya and profession as Engineer or Manager, then how to write query for it?
I am taking input from listbox...with multiple selection...l

Thanks in advance
0
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
Use the IN operator in the query.

Religion in ('Hindu', 'Muslim') AND/OR Caste in ('Kayastha','Kshtriya')
0
tinyprogram's Avatar, Join Date: Jan 2011
Go4Expert Member
shabbir...thanks for your reply...

but there are 'n' numbers of options and suppose the user opts for 'm' number of options, then how to write query?
0
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
It does not matter how many options user selects and you can add each of them in the IN query.
0
tinyprogram's Avatar, Join Date: Jan 2011
Go4Expert Member
ok...but I don't know that how many options that user will select at runtime...may be he can select 5 options out of 10, 10 out of 10 or any other number...

My question is how to run query when I am not sure about the number of options the user had selected.
0
thevikasonline's Avatar, Join Date: Nov 2011
Newbie Member
Make a separate search table which form indexes with others related tables. Fire your query direct to this table and make join with others table by the help of result you get from this.
0
jhonden's Avatar, Join Date: Sep 2011
Ambitious contributor
Do colone search for exact and prompt search.