Hi there

I am using the web to lead, wich is working 100%.
but we using it as an application form.
the moment a lead gets generated i need to create a contacts automatically, relate it to the campaign, end insert the info into email man.

i am a novice and my first attemp as a mysql trigger that looks something like this

DELIMITER $$

CREATE
TRIGGER `test`.`as` AFTER INSERT

ON `test`.`ad`
FOR EACH ROW BEGIN

INSERT INTO af (NAME,surname,age)

SELECT (NAME,surname,age)
FROM ad
WHERE date1 = (SELECT MAX(date1) FROM ad)

END$$

DELIMITER ;

but i get errors saying i cannot create the trigger.

any help will be appreaciated