delete record by set time.

[corillo181]

i ask this question before and i never got a good answer.

 

how do i delete record by time.

 

i want to delete every record that has not been active by a set time.

let say a month.

 

i can find in php the days since today and the given date

$days =  floor((time() - mktime(0,0,0,$d,$m,$y))/(60*60*24));

 

but how would i do this in mysql

 

SELECT ((NOW() - date)/(60*60*24)) as time FROM `tra_users_signup` WHERE signup_id='2'

 

[corillo181]

I GUESS I GOT IT TO WORK :|

IF ANYONE KNOW A BETTER WAY LET ME KNOW

 

SELECT FLOOR((UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(date))/(60*60*24)) as time FROM `tra_users_signup`

 

SHOWS THE DAYS FROM THE GIVEN TIME TO NOW IN MYSQL