[SOLVED] Help counting the number of days in inventory

[DBookatay]

I have a cell in my dB named 'pur_date' with the "date" value: 2009-07-03.

How do I count the number of days (based on todays date) that it's been in inventory?

[sasa]

look datediff() mysql function

[DBookatay]

look datediff() mysql function

 

I'm obviously doing something wrong cause this is not returning the right number of days...

// Days in inventory
   $date1 = date("Y").'-'.date(d).'-'.date("m"); 
   $date2 = $row['pur_date']; 
   $diff = abs(strtotime($date2) - strtotime($date1)); 
   $years = floor($diff / (365*60*60*24)); 
   $months = floor(($diff - $years * 365*60*60*24) / (30*60*60*24)); 
   $days = floor(($diff - $years * 365*60*60*24 - $months*30*60*60*24)/ (60*60*24));

   if ($years !="0") {$years = $years.' yrs, ';} else {$years = NULL;}
   if ($months !="0") {$months = $months.' mnths, ';} else {$months = NULL;}

   $daysIn =  $years.$months.$days.' days';

[DBookatay]

Anyone have any suggestions?

[DBookatay]

Anyone have any suggestions?

 

I solved it myself...

$date1 = date("Y").'-'.date(d).'-'.date("m"); 
----- should be -----
$date1 = date("Y").'-'.date(m).'-'.date("d");