strtotime and date

[slimjim]

Ok geeze I hope someone can help me....

This is not deleting correctly

//Date is going in like this...
.strtotime(date("d M Y H:i:s")).

//and looks like this
1110760560

I want to delete anything in the table that is older then 3 days..

Here is sorta what I have

   if (!$expdays) $expdays=90;
   $exptime=60*60*24*$expdays;

   $sqlexp="DELETE FROM event WHERE ((";

if ($news) $sqlexp .= "type='news' OR";

   $sqlexp .= " 0) and (rdate < ".(time()-$exptime)."))";
   q($sqlexp);

So using a form, if i chose to delete anything older then 3 days lets say.. it should delete anything older then three days.
So on the form, if the value for expdays is 3
But it isnt deleteing

[nephicheng]

your sql logic is off.

[Cailean]

Originally posted by nephicheng
your sql logic is off.

Well, that's incredibly helpful, isn't it?

Ok, let's sort out the date stuff first and then fix the query...

I'll assume you understand that [man]date()[/man] will produce a formatted representation of a 'seconds since the epoch' UNIX timestamp. If not, check the link and/or just ask.
[man]strtotime()[/man] creates a timestamp based on a given string.

So, the form returns the value '3' meaning three days... to determine the timestamp:

[$form_value=$_POST['value'];  // example: 3
$exp_string=$form_value." days ago";
$exp_time=strtotime($exp_string); // this now represents the timestamp from three days ago

Now we can build the query...

$query="DELETE FROM event WHERE type='news' AND rdate<$exp_time";
$r=mysql_query($query);

This assumes that you have filled rdate with UNIX timestamps using [man]time()[/man].