Cum fac sa scad 2 date de tip int in format Ymd

[ButcheR]

[DrStupid]

nu stiu la ce o folosesti .. dar ai putea sa o stergi din baza de date ..
[php]
if($data_de_azi == $data_din_db)
{
$query = delete......
$result = mysql_query($query)
}


[/php]:P

[ovi2ut]

[php]
function expire($data,$nr_zile_in_care_expira)
{
$year = substr($data,0,4);
$month = substr($data,4,2);
$day = substr($data,6,2);

$current_year = date("Y");
$current_month = date("n");
$current_day = date("j");

$dif_timestamp = mktime(0,0,0,$current_month,$current_day,$current_year) - mktime(0,0,0,$month,$day,$year);

$nr_days = $dif_timestamp/86400;

if ($nr_zile_in_care_expira <= $nr_days)
{
return true;
}
else
{
return false;
}
}[/php]

[Emil]

ai putea face asta direct din SQL daca nu ma insel ..

[ovi2ut]

Asta daca ar fi un camp de tip DATE, nu ?

[Emil]

[ButcheR]

[Emil]

[ButcheR]

anyway ovi2ut thx a lot...asta vroiam. Dar pt cultura mea generala se pot face operatii cu date pur si simplu sau tb folosit mktime, care transforma data in secunde si de acolo obtii tot ce vrei.