$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();
Please Log in to join the conversation.
Please Log in to join the conversation.
Please Log in to join the conversation.
Please Log in to join the conversation.
Please Log in to join the conversation.
Please Log in to join the conversation.