Jump to content

B_Thax

New Members
  • Posts

    1
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

B_Thax's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. 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]
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.