run delete query and delete a record each 24 hours in php and mysql

Question

I have a table named tbl_cartag and in table have temp field after user enter data must be erased after 24 hours.

I want this field to be cleared every 24 hours Information.

This is my query

DELETE cartag FROM tbl_cartag WHERE tcartagid=( $_GET['tcartagid'] )

I read similar questions , but I did not help

http://stackoverflow.com/a/1194864/3164682 – Sarath Aug 24 '16 at 07:39 — Sarath, Aug 24 '16 at 07:39

score 0 · Answer 1 · answered Aug 24 '16 at 07:40

0

If you're running on Linux/Unix (including Mac OSX), create a cron job.

if you are using windows then use event scheduler

it will work

answered Aug 24 '16 at 07:40

Kamlesh Gupta

score 0 · Answer 2 · answered Aug 24 '16 at 07:40

0

I think this option is better:

DELETE 
FROM YOUR-TABLE
WHERE
YOUR-DATE-COLUMN < DATE_SUB(NOW(), INTERVAL 2 DAY);

answered Aug 24 '16 at 07:40

Noman

score 0 · Answer 3 · answered Aug 24 '16 at 07:50

If you want to truncate/erase everything from temp table Then you can run the above query

DELETE cartag FROM tbl_cartag WHERE tcartagid=( $_GET['tcartagid'] )

also you have to create a cron job for this query.

Or if you want to erase 24 hours data from temp table then you have to add Data time query as mentioned by Syed noman

YOUR-DATE-COLUMN < DATE_SUB(NOW(), INTERVAL 2 DAY)

3 Answers3