I'm trying to create a trigger using phpcode!
As I test with SQLyog (winform application) the trigger is created!
But when I use phpmyadmin to execute that trigger code It's say some error!
And I try to use another code to connect to mysql database and execute the trigger code, the result is the same as using phpmyadmin!
So which php code can be used to create a trigger?
Thanks for help!
This is my trigger!
CREATE TRIGGER `trInsertUserToARO` AFTER INSERT ON `jos_users` FOR EACH ROW BEGIN
INSERT INTO `jos_adv_core_acl_aro` (`id`, `section_value`, `value`, `order_value`, `name`, `hidden`)
VALUES ((Select `id`+1 From `jos_adv_core_acl_aro_seq`), 'users', NEW.id, 1, NEW.name, 0);
SET id = id + 1;