I need to write a trigger with php but it do not seems to work. Here you got the code:
$sql_post_incrementor = "
CREATE TRIGGER post_incrementor BEFORE INSERT ON 'ksys_content'
FOR EACH ROW
UPDATE ksys_usr SET posts = posts + 1 WHERE id = 'NEW.author';
I get that error:
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DELIMITER $$ CREATE TRIGGER post_incrementor BEFORE INSER
MySQL trigger in PHP
1 reply to this topic
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users