if($_REQUEST['customerno'] !='') { $where .= "and customernum =".$_REQUEST['customerno']."; } if($_REQUEST['businesno'] !='') { $where .= "and businessrnum =".$_REQUEST['businesno']."; } like this u need to do With Regards Binoy.M.V --- On Wed, 6/1/10, rahul dongre <mady_dongre@xxxxxxxxxxx> wrote: From: rahul dongre <mady_dongre@xxxxxxxxxxx> Subject: serach To: "php" <php-objects@xxxxxxxxxxxxxxx> Date: Wednesday, 6 January, 2010, 7:59 PM hello all i want to add a searching functionality on my web page. my page contains following fields, customer no business no date tldno. now i have to make the functionlity like if user fill customer no then it serch accoring to the "customer no". if user fill customer no and business no then it serch accoring to the "customer no" and business no . abd so on.......... pplzz help thanks Rahul Dongre The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. http://in.yahoo. com/ [Non-text portions of this message have been removed] The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. http://in.yahoo.com/ [Non-text portions of this message have been removed]