If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Hi
Thank you so much for your reply
actually i have "ANY" option in all drop down boxes,so if they choose "ANY" they should get all the results from database,suppose they choose "ANY" option for country not for remaning onece,how can i write query in this situcation

Echo / print out $search_clause to see if it creates a proper SQL syntax. If so your good to use it! (of course there is no sanitization being done here though and nor does it handle the smarts around storing birthdays rather than arbitary ages)