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 ";
Aucun commentaire:
Enregistrer un commentaire