mktime and date function issues

VooDooRT

I'm trying to get a date that's 60 days in the past and bring it up in a while statement and send a SQL function to delete anything over 60 days in my database, however, when I echo the date, all I get it 1969-12-31

Here is the code:

<?php
include("db_connect.php");

$result = @mysql_query("SELECT date_rec FROM orders WHERE rec = '1'");
while($days = mysql_fetch_array($result)){
$today = date( "Y-m-d", time() );
$yesterday = mktime (0,0,0,date("Y") ,date("m")-2,date("d")); 
$before = date("Y-m-d",$yesterday);
if ($days['date_rec'] >= $before){
echo"<br>$before";
$result1 = @mysql_query("DELETE * FROM orders");
}
echo("
<body bgcolor='#00004a'><center><font color=#cccccc size=1 face=arial>$before<br>

All received items have been deleted from the database. 
			");
}
//<META HTTP-EQUIV=\"Refresh\" CONTENT=\"5; URL=churchs_options.htm\">
?>

VooDooRT

Ok, I got everything to work, but now I can't get it to delete the entries. Ideas?

<?php
include("db_connect.php");
$num = 1;
$result = @mysql_query("SELECT date_rec FROM orders WHERE rec = '1'");
while($days = mysql_fetch_array($result)){

$today = date( "Y-m-d", time() );
$yesterday = mktime (0,0,0,date("m")-1 ,date("d"),date("Y")); 
$before = date("Y-m-d",$yesterday);
$recd = $days['date_rec'];
if ($recd <= $before){
$sql = 'DELETE FROM orders WHERE date_rec < $before';
@mysql_query("$sql") or die ("<p>$sql:  $recd is before $before<P>".mysql_errno().": ".mysql_error()); 
$num++;
}
}
echo("
<body bgcolor='#00004a'><center><font color=#cccccc size=1 face=arial>
<META HTTP-EQUIV=\"Refresh\" CONTENT=\"5; URL=churchs_options.htm\">
$num items have been deleted from the database.  Please wait while you are forwarded back to the admin menu.
			");
?>

mogster

Ehm.. not sure I've got the gist of this, but:
You want to delete "yesterdays" records, that's it?
Depending on which format you store the date_rec as, you could do this directly without the first request. And you don't need the if-else sentence.

## Delete all record prior to today ##
$today = date( "Y-m-d", time() );
$sql = 'DELETE FROM orders WHERE date_rec < '$today';
@mysql_query($sql);

But I would test this on test-db before deleting in production db 😃
And the best reference to delete by would be if the date_rec was a unix timestamp, in my opinion.
But then, I don't know if it is 😉

knutm

mogster

Ah - now I read your first post :p Not yesterday, but yester60days 😃

60 days may be calculated like this:

$oldtime = time() - (86400*60);
$oldtime = date("Y-m-d", $oldtime);

But it would help to know the time-format in the db.

knutm