I need to write a trigger with php but it do not seems to work. Here you got the code: [b] $sql_post_incrementor = " DELIMITER $$ CREATE TRIGGER post_incrementor BEFORE INSERT ON 'ksys_content' FOR EACH ROW BEGIN UPDATE ksys_usr SET posts = posts + 1 WHERE id = 'NEW.author'; END$$ DELIMITER ;"; $res_usr=mysql_query($sql_post_incrementor,$dbd);[/b] I get that error: [b]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[/b]