Is it possible to delete an entry from a database that has been there for a set amount of time, say a week or a month? I thought that if the database has a timestamp entry and then I used something like:

PHP Code:

<?php
$con = mysql_connect("hostname/server IP","username","password");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("databasename", $con);
mysql_query("DELETE FROM table_name WHERE time > 'date('dS F Y')+7'");
mysql_close($con);
?>

Thanks

Don't think your syntax will work.

But, this should work:

PHP Code:

<?php

$con = mysql_connect("hostname/server IP","username","password");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("databasename", $con);
$sql = mysql_query ("SELECT FROM table_name");
$row = mysql_fetch_array ($sql);

if ($row['timestamp'] <= strtotime ('-1week',time())) {
    $delete = mysql_query("DELETE FROM table_name WHERE id='".$row['id']."'");
}

mysql_close($con);

?>

brilliant thank you

OMG WTF, scan the table in a cycle and delete records obe by one?

delete from tablename where date_sub(now(), interval 1 week) > timefield

When will you guys start reading the manual?

lol...

slightly off topic, but is it just me who wishes the MySQL manual was as easy to use as the PHP one? i can never find what i need on mysql

Dan

Dan, that just because you are not looking at the right place.

If you are looking for functions, simply search for "time functions" or "string functions".
If you are looking about the syntax, look up the select, update or delete help pages.

But if you are looking about the different joins, it's true that it won't be covered by the manual, or very lightly.
And it's not the place to learn about the SQL syntax.
You have pages like http://technet.microsoft.com/en-us/m...chNet.10).aspx and http://www.sql-tutorial.net/SQL-JOIN.asp for that.

Once that you know how to structure the query, you know everything you need.
The rest is just optimisation (or almost).
But I won't start about set based programming. It's friday, for god sack...
3 more hours before a good fresh beer....

There is a nice mysql manual in chm format right in mysql website
http://downloads.mysql.com/docs/refman-5.1-en.chm