I'm trying to make a search by different option say A, B . what i need is if user provide value of A only then it does the searching using parameter A only , if user provide A and B then it needs to do searching using condition A=value1 AND B=value2. How can i do this please help how can i start?
there are 5 fields in my program name, address, number, salary ,post i need to do the searching as for A,B,C provided A+B+C for A , D provided condition should be A+D. how many query state ment do i have to write?