Help with search form using multiple fields

I have a search form on a page that i am having trouble with. i can not seem to get the search string correct. In the form i have firstname, lastname, homephone, and email. I would like to upon search return data put in form. for example if i put "john" in firstname i want all rows where firstname is john to return. or if "john" is entered in firstname and "smith" is entered in lastname it will return all rows containing john smith. I have a frame set to display the data on the same page as the search page. I would also loke to data to print as a hyperlink pointing to userdata.php?custid={the PK ID of custid }. also if no text is entered and just search is pressed it will return all data in table asc by lastname. could someone please help with this? Thanks