Date

[Anon]

I need to ask a few questions

I am adding items to my database and need to add a date (time not required) so i can go back and check to see how long they have been there.

Then from that date Im going to use a script to check data for how long its been there. If it has been there for over a certain period of time I want to delete it.

So what date function should i use. and what field type in the mysql database should i use.(DATE / DATETIME).

Please help if you can.

Lee

[tomhath]

There are a couple of good sections in the manual that describe how to do exactly what you have asked. Are there any specific questions you have about the information that's in the manual?

3.3.4.5 Date Calculations

MySQL provides several functions that you can use to perform calculations on dates, for
example, to calculate ages or extract parts of dates.

To determine how many...

[tomhath]

Also check the php manual for the strtotime function. It also can do what you want.

[Anon]

if you want to check for how long data has been in the database, use the time() directive and then subtract it from the time now. like $timenow=time();

if ($timenow > time already in mysql database +3600 (seconds)*time allowed to stay in database) {

delete/rename whatever

or use

$today = mktime(0,0,0,date("m"), date("d"),date("Y"));

this is the date, always unique for each day.

[Anon]

Thanks for your help chaps. I will get to work on these items.

Thankyou