Query problem

[link7722]

    I have a table with multiple fields (date, username, job...) and i want to make a search form in which i will be able to search based on any field (combining more than one field, but not necesserilly all).My problem is that when i retreive the variables from the form , some of them might be empty and so the query won't return the right reults.

Query:

SELECT * from table_name WHERE table_username = username_variable AND table_date = date_variable .....

  I think that with multiple elseif statements (executing different queries in each case if one variable is null  ) i will get the results i want, but i guess there must be a quicker and most proper way to achieve that.

Thanks

[Barand]

my method

 

http://www.phpfreaks.com/forums/index.php/topic,198579.msg896711.html#msg896711