Essentially this is what I want to do.

Say I register today on the 13 OCT 2008. I want my php scrip to pull the date from the database. And when its been in the database for more then 45 days. I don't want it to display on the page.

Any help would be appreciated.

Thank you,

Red_X_

Add the fields like 'Killonthisday' and 'active'. Use a cron (which runs daily) to change the active field to say something like 'no' on the date set in 'Killonthisday'.

Alternatively, you could make the SQL query be all like "If the date is more then 'date' don't show it", but I'm not 100% on how to do that

Originally Posted by rogem002

Add the fields like 'Killonthisday' and 'active'. Use a cron (which runs daily) to change the active field to say something like 'no' on the date set in 'Killonthisday'.

Alternatively, you could make the SQL query be all like "If the date is more then 'date' don't show it", but I'm not 100% on how to do that

I would like to do it in PHP. ^^ But thanks.

All I want is to take the current day and add it up by 45 to get the next date. :S But I can't seem to figure it out. I see ones using mktime...but there must be a easier way.

There are various ways you could do this. Problems arise due to differing way PHP and Mysql deal with dates. Php uses the unix timestamp integer and Mysql uses a DATETIME string.

This uses Mysqls date manipulation. Add a new column/field to your register table such as 'date_insert' to your table 'tbl_name' with a TIMESTAMP datatype and with a default of current_timestamp. When a new record is inserted this value will be given the current date as a datetime string not as a UNIX timestamp.
MYSQL code

         ALTER  TABLE  `tbl_name`  ADD  `date_insert` TIMESTAMP NULL  DEFAULT CURRENT_TIMESTAMP

Then when you do your select statement

PHP Code:

$SQL ="SELECT * FROM tbl_name WHERE DATE_SUB( CURDATE( ) , INTERVAL 45 DAY ) <= 'date_insert'  "; 


This will select all rows that have a datetime string within past 45 days.

Originally Posted by maxxximus

There are various ways you could do this. Problems arise due to differing way PHP and Mysql deal with dates. Php uses the unix timestamp integer and Mysql uses a DATETIME string.

This uses Mysqls date manipulation. Add a new column/field to your register table such as 'date_insert' to your table 'tbl_name' with a TIMESTAMP datatype and with a default of current_timestamp. When a new record is inserted this value will be given the current date as a datetime string not as a UNIX timestamp.
MYSQL code

         ALTER  TABLE  `tbl_name`  ADD  `date_insert` TIMESTAMP NULL  DEFAULT CURRENT_TIMESTAMP

Then when you do your select statement

PHP Code:

$SQL ="SELECT * FROM tbl_name WHERE DATE_SUB( CURDATE( ) , INTERVAL 45 DAY ) <= 'date_insert'  "; 


This will select all rows that have a datetime string within past 45 days.

I just made another field in the database called exdate. And figured it out, after some research.

PHP Code:

$datex = date("Y-m-d", strtotime("+45 days")); 


I ran into the exact issue about a month ago, what was the final solution?

Originally Posted by JohnColonJr

I ran into the exact issue about a month ago, what was the final solution?

PHP Code:

$datex = date("Y-m-d", strtotime("+45 days")); 


There you go.