$gender ="Male";
$stmt = $connect->prepare("
	SELECT users.email,user_c.id AS user_id, user_c.firstname
 	AS user_firstname, partner_c.id AS partner_id, partner_c.firstname 
	AS partner_firstname
	,partner_c.lastname
	,partner_c.cb_religion
	,partner_c.cb_functionalarea
	,partner_c.avatar
	,partner_c.cb_dateofbirth
	FROM t4qcm_comprofiler AS user_c
	JOIN t4qcm_comprofiler AS partner_c 
	ON user_c.cb_complexion2 = partner_c.cb_complexion
	AND user_c.cb_religion2 = partner_c.cb_religion
	AND user_c.cb_smoking2 = partner_c.cb_smoking
	AND user_c.cb_drinking2 = partner_c.cb_drinking
	AND user_c.cb_eatinghabits2 = partner_c.cb_eatinghabits
	AND user_c.cb_height2 = partner_c.cb_height
	AND user_c.cb_weight2 = partner_c.cb_weight
	AND user_c.cb_maritalstatus2 = partner_c.cb_maritalstatus
	AND partner_c.cb_gender != user_c.cb_gender
	AND partner_c.cb_gender = '$gender'
	INNER JOIN t4qcm_comprofiler_members AS members
	ON user_c.id = members.referenceid
        AND partner_c.id != members.memberid
	INNER JOIN t4qcm_users AS users ON user_c.id = users.id
	LIMIT 0 , 30");

	$stmt->bind_param("s",$gender); 
	$stmt->execute();
		$stmt->bind_result($useremail,$userid,$userfirstname,$partnerid,$partnerfirstname,$partnerlastname,$partnerreligion,$partnerfunctionalarea,$partneravatar,$partnerdob);
$stmt->store_result();