0

Just for efficiency is it possible to use $org_id in both ?'s without specifying it 2 times in the $paramValue array ?

$org_id = "111"
$query = 'UPDATE tbl_member_settings SET eto = (SELECT submit_email FROM tbl_org_subscriptions WHERE org_id = ?) WHERE member_id IN (SELECT id FROM tbl_member WHERE org_id = ?)';
        $paramType = 'ss';
        $paramValue = array(
            $org_id,
            $org_id
        );
Dharman
  • 26,923
  • 21
  • 73
  • 125
Catalyph
  • 33
  • 3

0 Answers0