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] Link to comment https://forums.phpfreaks.com/topic/16023-mysql-trigger-in-php/ 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? Link to comment https://forums.phpfreaks.com/topic/16023-mysql-trigger-in-php/#findComment-67840 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.