What method do we use to create an event listener?

MySQL get the date n days ago as a timestamp

Error in CREATE table statement in MySQL SQL query: MySQL said: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') NOT NULL, `seachtext` text NOT NULL, `view` int() NOT NULL )' at line 2