[SOLVED] Enter a date into MYSQL + 2 weeks

[fry2010]

I have already posted but my post been ignored.

All i want to do is generate todays date. Then add 2 weeks to this or 14 days. Then put this into mysql as a correct mysql date, i.e.  Y-m-d.

Can anyone point me to what I should be looking at?

[Darklink]

$timenow = time() + 1209600;
mysql_query("UPDATE tblRow SET date_created='FROM_UNIXTIME({$timenow})' WHERE id=1");

 

FROM_UNIXTIME() simply converts a timestamp into it's date.

 

And yes... 2 weeks is 1,209,600 seconds.

[fry2010]

awesome mate, thanks for the reply. I havnt actually tried it yet I have other annoying problems atm, but that is something I havent come across and looks right.

Cheers.

[fry2010]

just another one while your here, say I wanted to then check those dates I put into it, so like :

 

Person registers. expire is set to 2 weeks from now. I check this expiry date when they go to another part of the site, with todays date.

[jitesh]

check DATE_ADD and INTERVAL in Mysql

[fry2010]

thanks jitesh, but i have tried using those with INSERT and it doesnt work.

It seems the only way to use DATE_ADD and INTERVAL is through a SELECT statement because there is nothing in the docs about INSERTING this information. Not that i can make out anyway.