CREATE TRIGGER marketing_list_update
AFTER UPDATE
ON cms_offers
FOR EACH ROW
begin
IF NEW.status = 'active' then UPDATE marketing_credits_requests SET sum_a=NEW.ammount, statut=NEW.status WHERE id_req=old.id;
else UPDATE marketing_credits_requests SET statut=NEW.status WHERE id_req=old.id;
END IF;
end;
CREATE TRIGGER marketing_list_update
AFTER UPDATE
ON cms_offers
FOR EACH ROW
IF NEW.status = 'active' then UPDATE marketing_credits_requests SET sum_a=NEW.ammount, statut=NEW.status WHERE id_req=old.id;
else UPDATE marketing_credits_requests SET statut=NEW.status WHERE id_req=old.id;
END IF;
<pre class='xdebug-var-dump' dir='ltr'>
<small>/home/map/api.site.xyz/api/register/step_1/register.php:147:</small><small>string</small> <font color='#cc0000'>'{ "type": "Answer", "code": 400, "status": "Error" } '</font> <i>(length=66)</i>
</pre>[]
<pre class='xdebug-var-dump' dir='ltr'>
<small>/home/map/api.site.xyz/api/register/step_1/register.php:152:</small><small>string</small> <font color='#cc0000'>'{ "type": "Answer", "code": 400, "status": "Error" } '</font> <i>(length=66)</i>
</pre>