B_Thax Posted July 30, 2006 Share Posted July 30, 2006 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 BEGINUPDATE 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] Quote Link to comment Share on other sites More sharing options...
fenway Posted August 2, 2006 Share Posted August 2, 2006 I assume you're using a trigger-friendly version of MySQL? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.