Re: Date difference

Lots of ways to do it, here's one. Convert them both to unix timestamps and subtract. $nowstamp=mktime() ; $result=mysql_query(SELECT UNIX_TIMESTAMP(mydatefield) AS dbdate FROM mydatabase); $row=mysql_fetch_array($result); $dbdate=$row["dbdate"]; $thedifference=$nowstamp - $dbdate; //above gives you the difference in seconds. $daydifference = intval($thedifference / 86400); // 86400 is number of seconds in a day // intval because I don't want partial days, just number of days // $daydifference above gives you the difference in days kind regards, bill ravi@nls.ac.in wrote: > Dear Friends, > > I am accessing a MySQL database through PHP. > > I have to calculate the difference between todays date and the date obtained > from MySQL database. > > The Database string is in the form of \"yyyy-mm-dd\". > > I have to convert the above string into unix timestamp so that i can calcualte > the difference between the two time stamps. > > Please help me in this regard. > > Thanking you, > > B. Raveendra Reddy > National Law School of India University > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net