mysql how to search three field in database

I want to user to search each field separate or two fields, or all three according to want he/she want (all are in the same table)

Example1: user can select gender MALE status “PAID”

Example2: user can select status paid Renewal_status NOT RENEWAL

Example3: user can select gender female Renewal_status NOT RENEWAL and etc.

Here is my codes:

$sql = "SELECT * FROM member WHERE Gender='$advocate_gender' OR Status='$advocate_pcstatus' OR Renewal_status='$renewal_status' ORDER BY RollNo ";