使用php mysql在报告中使用多个搜索表单

i am doing one project by using PHP Mysql. I have finished all the modules now am getting struck in Reports. The client want the report with multiple search options. i have four fields 1). Serial Number, 2). Value, 3). Date, 4). location. if the client select serial number and date means report should be display with selected serial number and also date. But my select query is not working its fetching all the data's.i am doing one project by using PHP Mysql. I ha