Hello everyone


how do I add on one year???

this gives me my date but I need to add 1 year
'".date("Y-m-d H:i:s", strtotime(mysql_real_escape_string($exp_date)))."',


I tried this --- but it failed (i'm trying to set a future expiry date)
'".date("Y-m-d H:i:s", strtotime(mysql_real_escape_string($exp_date "+1 year")))."',


ALSO i'm unsure about this

on MySQL INSERT I use now() to add another date field

do I need to use mysql_real_escape_string around now()


thanks

LT

What does $exp_date look like before its ran through the date function

Hi seco

Expiry date is expected like this

00:31:02 Nov 03 2010 PDT


ALSO i'm unsure about this

on MySQL INSERT I use now() to add another date field

do I need to use mysql_real_escape_string around now()


Thanks

ps If I can't add one year to my set up as i have it now, I guess I could rearrange and not use teh date var that I am getting

LT

<?php
$date = date("Y-m-d H:i:s", time() + 60 * 60 * 24 * 365); // now + one year
?>

Thanks poyzn

any idea on

ALSO i'm unsure about this

on MySQL INSERT I use now() to add another date field

do I need to use mysql_real_escape_string around now()

I'm not using at the moment but wonder if I should / need to??

LT

<?php
$date = date("Y-m-d H:i:s", time() + 60 * 60 * 24 * 365); // now + one year
?>

echo date("Y-m-d H:i:s", strtotime("Now + 1 year"));

Thanks all

yeh I have this bit now:-)

one small step and all that eh what:-)

LT

Thanks poyzn

any idea on

ALSO i'm unsure about this

on MySQL INSERT I use now() to add another date field

do I need to use mysql_real_escape_string around now()

I'm not using at the moment but wonder if I should / need to??

LT

No, you don't need to use mysql_real_escape_string around now()

Thanks

I was still wondering hahahhahaa

assumed my question was dumb hahhahaha

LT