delete rows that are 10 days old

[slimjim]

Here is what I have :
I use datetime for type in mysql
Which stores date and time like 0000-00-00 00:00:00

if Is older then 10 days, then delete those entries...
field name where datatime is stored is called datetime

    $query="delete from posted where memid='$uid'"; 
	mysql_query($query) or die( "ERROR: " . mysql_error() . "\n");

[George_hu]

Is that was a question ?

If so, here is as i delete old entries>

<?
$link = mysql_connect("localhost", "db_name", "******");
mysql_select_db("db_name", $link);


$time = date("Y-m-d", mktime(date("H"), date("i"), date("s"), date("m"),
date("d")-10, date("Y")));

// echo $time;

$query = ("DELETE FROM `popularity` WHERE TO_DAYS(NOW()) - TO_DAYS(timestamp) >= 10");
mysql_query($query);



?>

[slimjim]

yes, i need to know how to do this, how ever you use timestamp in database and I use datetime...

Not sure if what your using would work...

[Roger_Ramjet]

date and time functions are what you need, not messing around in php.

And even though datetime is not on the RESERVED WORD LIST for backward compatibility, it is still not a good idea to use it for a column name. So I have changed it in this example. Use names that are meaningfull.

$sql = "DELETE FROM posted 
       WHERE post_timestamp < DATE_SUB(NOW(), INTERVAL 10 DAY)"