$date = mysql date field 2005-09-23 for example $difference =ceil((strtotime($date) - time()) / 86400); strtotime is far nicer than mktime when you already have a date field ready. On Friday 23 September 2005 03:10 pm, Philip Thompson wrote: > On Sep 23, 2005, at 11:16 AM, Chris W. Parker wrote: > > Philip Thompson <mailto:prthomp@xxxxxxxx> > > > > on Friday, September 23, 2005 9:12 AM said: > >> I'm needing to find the number of days between two dates without > >> using an database functions (DATE_SUB, etc)... only PHP. Is there an > >> easy way to accomplish this? I have searched the PHP site, but have > >> not been successful in finding anything that will assist me. > >> > >> Any help would be appreciated. > > > > There might be an easier way but... convert to timestamp, subtract > > smaller number from bigger number, figure out how much time has > > passed. > > Chris. > > I actually discovered how to do this right after I made the post. I > looked at some archives and worked this out. > > <code> > > // today - 9/23/05 > $start = mktime(0, 0, 0, date("m"), date("d"), date("Y")); > > // the objective day - 3/15/06 > $end = mktime(0, 0, 0, 3, 15, 2006); > > // subtract today from the objective and divide by 24*60*60 to get days > $difference = ceil(($end - $start) / (86400)); > > </code> > > Thanks for your assistance. > ~Philip -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
