To Display Remaing Time In Days

I am not sure exactly what you want, but there have been 2 recent threads about time and date things

Date Stamp and live clock

and

Displaying time left

I hope these help you find a solution

Hi theSofa

In what format does phprunner store the date, ie. unix time stamp or other. i need to compare this field to the current date, now() and display how many days are left.

just use the php functions and you will be fine

Hi

I have found by adding a decimal value (as below) to the time now (ie, $mytimestring) , gives me the current date PLUS a decimal value of part of a year, so I can calculate current date plus say 6 months ($mytimeString + .5 >= $expireddate) and compare it to the expiry date. But I am sure there must be a better way, I would like to be sure that it is correct to the nearest day.

$mytimeString = date("Y-m-d",strtotime("+6 hour"));

$expireddate = $values['ItemtExpires'];

If ($mytimeString + .5 >= $expireddate) {echo "Item will within 6 Months";} ELSE {ECHO "ITEM IS OK";};
Any Ideas

Is there a better way to do this.

There is a number of ways to calculate a difference between two dates in PHP code. Here is the article that provides sample code:

http://www.developertutorials.com/tutorial...1018/page1.html
More info: http://www.google.com/search?q=calculate+date+difference+php

Ok, So the first thing I would need to do is use explode to extract the date time data from the database stored by phprunner, then possibly convert it to seconds and do the same with the current time, subtract one from the other and then convert the result back into days.

Try this

[codebox]<?php

//Count Down of Days:Hours:Minutes:Seconds

//

//Date/Time counting down too.

$datetime=strtotime( "2008-09-01 11:00" );

//Retrieve the current date/time

$date2=strtotime("NOW");

echo $date2;
if ($datetime < $date2) {

print "The Event is here!! or over with!!
".$date2." is greater than ".$datetime."
";

} else {
//List total time by type

//Seconds

echo "total seconds remaining: ".(($datetime-$date2)). "
";

$holdtotsec=(($datetime-$date2));

//Minutes

echo "total minutes remaining: ".(($datetime-$date2)/60). "
";

$holdtotmin=(($datetime-$date2)/60);

//Hours

echo "total hours remaining: ".(($datetime-$date2)/3600). "
";

$holdtothr=(($datetime-$date2)/3600);

//

//Days - a day is a 24 hour period

//This gives days remaining

$holdtotday=intval(($datetime-$date2)/86400);

echo "total days remaining: ".$holdtotday. "
";

//

//Find hours remaining - get days in hours and sub from tothr

$holdhr=intval($holdtothr-($holdtotday24));

echo "hours remaining: ".($holdhr). "
";

//

//Find minutes remaining - get days and hours in minutes and sub from totmin

$holdmr=intval($holdtotmin-(($holdhr60)+($holdtotday1440)));

echo "minutes remaining: ".($holdmr). "
";

//

//Find seconds remaining - get days hours minutes in seconds and sub from totsec

$holdsr=intval($holdtotsec-(($holdhr3600)+($holdmr60)+(86400$holdtotday)));

echo "seconds remaining: ".($holdsr). "
";
}

?>[/codebox]

Your other option is to do it all at the database level as oracle, microsoft sql and mysql all have datetime funcions, you could then return this just like any other field.