Hi Monks
I have 3 different variables. I try to create a query based on the existence of 1,2 or all 3 of the variables.
Example:

select * from <table> where colum1="$var1" and column2="$var2" and col
+umn3="$var3";
[download]

However, since it is not necessary that all 3 are defined, there are many
combinations possible ($var1 exists, others don't etc.)
It depends on user as to how many variables he is looking for
Is there a way I can create a single query which takes care of existence of the three variables
without me having to use 6 if/else statements?
Thanks for the help,