[RESOLVED] searching mysql by timestamp and date

[fr8]

I have looked at both date and mktime but i dont see how i can get the days passed.

I just dont understand how i can take:

$lastmonth = mktime(0, 0, 0, date("m"), date("d")-3,  date("Y"));

and turn it into #threedaysago

$threedaysago = 20051128224433;
//if the current time were this.
$currenttime = 20051201224433;
// $currenttime is how my dates are stored in mysql.

Once i were to get that number then i could do a simple >= search in mysql to bring up all records that are no older than 3 days.

[fr8]

solved it after walking away for a while and taking a new look.

$currenttime=date('YmdHis');
$threedaysago = mktime(0, 0, 0, date("m"), date("d")-3,  date("Y"));
$newtime=date('YmdHis', $threedaysago);