Mysql date manipulation

[beyondflash]

I have a date comming from mysql yyyy-mm-dd I need to be able to distinguish if this date is over 1 year old.

The date is also in an array:
$mydate[$i] = yyyy-mm-dd;

I need a function that will return a true or false if each date in the array is a year old.

Thaks,
Mike

 

[KarveR]

select date_field,if(date_field = date_sub(curdate(), interval 1 year),"True",False") as true_false FROM database WHERE ....;

you now receive true_false in your array and it will tell you

______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.

 

[beyondflash]

I don't want it a mysql function...I need it a php function so I can tell the user that that particular product they purchased is expired (they will have more than one product purchased.)

 

[KarveR]

You can evaluate the returned field, (use 1 for true,0 for false)
if($myArray[$i] == "1"){
echo "product expired";
}else{
...
}

______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.

 

[beyondflash]

I go tit ... here is what I did:

$mydate= explode("-",$DBDate[$i]);
$year=$mydate[0]+1;
$month=$mydate[1];
$day=$mydate[2];
$expiredate=$year."-".$month."-".$day;
$today = date("Y-m-d");
$days[$i] = floor((strtotime(date("Y-m-d")) - strtotime($expiredate)) / (60 * 60 * 24 * -1) );
if($days[$i] <=0){
$expired[$i]=1;
}else{
$expired[$i]=0;
}


it may be "bulky" but it works.

 

[beyondflash]

That was inside a for loop with the size of array as a limiter.

 

[beyondflash]

it also calculates how many days is left before expiration at the same time. And I display that later using days[$i]

 

[KarveR]

depending on version of mysql, datediff could do that, saving you lots of programming while building more advanced mysql queries.

horses for courses tho glad you found a solution.

//karv

______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.