Using MySQL triggers with PHP

I can’t seem to make this work. I’ve been feeding this into a MySQLi object:

   DELIMITER |
	CREATE TRIGGER trigger AFTER INSERT ON msp_account
   	FOR EACH ROW BEGIN
   		INSERT INTO log_table_change (
            table,
            table_id,
            user
            )
         VALUES (
            'test_table',
            NEW.msp_account_id
            'test_user'
            )
      END
	|

… and using the multi_query() method, But never seems to work. No errors, just no work.

I got it to work. I had neglected to include a semi-colon at the end of the INSERT statement. Here 'tis:

$mysqli = new mysqli(MYSQL_HOSTNAME, MYSQL_USERNAME, MYSQL_PASSWORD, MYSQL_DATABASE);
$mysqli->query("DROP TRIGGER trigger1");
$sql = "
   CREATE TRIGGER trigger1 BEFORE INSERT ON account
      FOR EACH ROW BEGIN
   		INSERT INTO log_table_change (
            `table`,
            `table_id`,
            `user`
            )
         VALUES (
            'account_entered',
            NEW.account_id,
            'test_user'
            );
      END;
   ";
$mysqli->multi_query($sql);
$mysqli->query("INSERT INTO account (username) values ('asdasdasd')");
$mysqli->close();