how to auto delete by PHP+MYSQL in a giv

[Anon]

A new user sign up an account, but don't activate it in a given time, So his
sign-up record need to be deleted from the db.
Can I use PHP+MYSQL to delete it automatically in a given time, if yes,
could you please tell me how?

[[deleted]]

You will have to make a script that checks for these 'outdated' records and deletes them.
Then use the crontab or something to run that once script every day.