I am look for some help with a query where the query changes on the basis of input parameters.
$variable = 'abc'; $rs=mysql_query("SELECT * FROM table WHERE `column`='$variable'");
But what about a scenario where this variable is not assigned or is null or blank. In that case I'd like the query to ignore that column altogether and look into other parameters.
I have been looking into it for a while but haven't found anything useful. I am not even sure if its possible. Any help or inputs will be appreciated!