I am working on a social network were users create a post But this post is not permanent so the user have to set the duration of time they want the post to be seen but i can't use create event on runtime, I have this code to test creating event that will insert a row into my db in 10 second but it is not working on runtime but when i use the same code in my phpmyadmin environment it will work fine i have been trying to figure it out but not yet please i need help.
<pre>DELIMITER | CREATE EVENT stop_fad_1 ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 10 SECOND ON COMPLETION PRESERVE DO BEGIN insert into hide_fad(userid,fad_id)values(11,38); END | DELIMITER ;
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)