Click here to Skip to main content
15,891,883 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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.


What I have tried:

SQL
<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 ; 
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900