PHP Date Help
Posted: Mon Aug 02, 2010 6:57 am
Hi Guys,
I'm not the best coder in the world, i'll attempt new/different things every now and again...
I've created a signup script to a website, where i have added an Update set **sign up's name** into a field called 'datesignup' on my MYSQL Db.
set users datesignup=$now
$now being: $now = date("m-d-y h:i:s A T");
When the user signs up it adds the date of the sign up into a field on a MYSQL DB as desired but..
I'm trying to use this date an replicate it on another page on my website where it shows when the user signed up.
I want it too state "Member for: ** years, ** Months, ** days, **Minutes .... but i cant seem to work out how to do this..
Currently im using print"Member For: $get[datesignup]<br>"; which is stating the date as 08-02-10 07:24:46 AM EDT which is what's being added in the signup script.
Anyone know how i can get this working - Apologise if wrong forum but it's my first post!
I'm not the best coder in the world, i'll attempt new/different things every now and again...
I've created a signup script to a website, where i have added an Update set **sign up's name** into a field called 'datesignup' on my MYSQL Db.
set users datesignup=$now
$now being: $now = date("m-d-y h:i:s A T");
When the user signs up it adds the date of the sign up into a field on a MYSQL DB as desired but..
I'm trying to use this date an replicate it on another page on my website where it shows when the user signed up.
I want it too state "Member for: ** years, ** Months, ** days, **Minutes .... but i cant seem to work out how to do this..
Currently im using print"Member For: $get[datesignup]<br>"; which is stating the date as 08-02-10 07:24:46 AM EDT which is what's being added in the signup script.
Anyone know how i can get this working - Apologise if wrong forum but it's my first post!