Why did you change 

mysql_real_escape_string($eventDate)
to
mysql_real_escape_string($_POST[$date])
? (im not worried about variable name changes, why are you referencing the global variable, instead of the one you just passed in?)