MySQL / PHP Create Event Syntax Error

Asked Jun 23 '17 at 08:22

Active Jun 23 '17 at 08:22

Viewed 16 times

I'm getting a 1604 syntax error in my sql query trying to create an event.

The query runs fine in phpmyadmin so I'm not sure what is wrong here.

Here is my SQL:

CREATE EVENT 'exp_$evtname' ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 HOUR ON COMPLETION NOT PRESERVE ENABLE DO UPDATE `members` SET `token` = '' WHERE `memberID` = '$memid'";

and the page is giving the error: "

1064: You have an error in your SQL syntax ... near ''exp_wbjlc' ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 HOUR ON COMPLET' at line 1

Any insight on what's going wrong here?

Thanks!

asked Jun 23 '17 at 08:22

Carter Roeser

Try double quotes on 'ex_$eventname' – Andrei Todorut Jun 23 '17 at 08:25
double quotes everywhere do use php variables inside – Andrei Todorut Jun 23 '17 at 08:26
@AndreiTodorut changing it to double quotes caused a 500 error. – Carter Roeser Jun 23 '17 at 09:01

MySQL / PHP Create Event Syntax Error

0 Answers0