I'm having an issue with my PHP code trying to create events within MySQL. I begin with creating a string like this:

$sql="DELIMITER $$ CREATE EVENT `$test_name` ON SCHEDULE EVERY $time1 $sched2 
STARTS '$start_date $start_time' DO BEGIN ";
$sql .="INSERT INTO blah (foo,bar); ";
$sql .="END$$ DELIMITER ;"

mysql_query($sql,$dbh);

But I keep getting Syntax Errors starting with DELIMITER $$ CREATE EVENT. Without the semicolon behind (foo,bar); the event triggers with a unexecuted payload.

Any ideas on where I'm going wrong?

Thanks!